MySQL Forums
Forum List  »  Optimizer & Parser

query index not used
Posted by: Adrian Petre
Date: August 15, 2013 05:23AM

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 ?

Options: ReplyQuote

Written By
query index not used
August 15, 2013 05:23AM
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.