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]

Reply via email to