Re: possible_keys exist but key is NULL
The type of the query is system, wich means that there's only one row in your table.
MySQL won't use the index because in such case it's worse than reading the whole table.
Add some more rows in your table and MySQL will use your index.
Thomas CORBIERE
Subject
Views
Written By
Posted
10554
February 22, 2006 11:29AM
Re: possible_keys exist but key is NULL
4449
February 22, 2006 02:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.