John.H wrote:
but why when I do a query with 'explain' ,it shows that the 'possible_keys' is null or primary rather than the index I just create
Please always CC the list - you will get much faster responses and others will be able to offer their input as well.
Post the query, the explain and the indexes you have on the table(s) and someone might be able to help.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]