MySQL Forums
Forum List  »  Optimizer & Parser

Re: possible_keys exist but key is NULL
Posted by: Thomas CORBIERE
Date: February 22, 2006 02:12PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
10208
February 22, 2006 11:29AM
Re: possible_keys exist but key is NULL
4339
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.