query index not used
Hi, I have the following simple self-explained query:
SELECT items.*
FROM gallery.items
WHERE left_ptr <= 7776
Mysql EXPLAIN output:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE items ALL PRIMARY,left_ptr,right_ptr NULL NULL NULL 4858 Using where
I have an index on left_ptr; why is not used ?
Subject
Views
Written By
Posted
query index not used
2041
August 15, 2013 05:23AM
1159
August 31, 2013 03:41PM
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.