MySQL Forums
Forum List  »  Newbie

index performance on "limit" condition
Posted by: Ed Wong
Date: February 21, 2010 09:11PM

hi all,

some questions on index performance

query 1: select * from table where title='abc' limit 20;
(title is not indexed)
will the query go through the whole table content or just the first 20?
the "explain" statement shows that it go over all rows... but want to confirm

query 2: select * from table where title not like 'abc%';
(title is indexed -> trying to look for title that does not begin with abc)
will the query go through the whole table?



Options: ReplyQuote

Written By
index performance on "limit" condition
February 21, 2010 09:11PM

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.