Re: Not using index optimal

[Jørgen Løland]

Hi Per,

You are right to be suspicions about this. Unfortunately, the EXPLAIN output is wrong for this query. MySQL does as you want it to, i.e., it reads 100 rows, returns them and nothing more.

"Using where" means that MySQL matches the content in the index with the conditions you provided. Take a look here for more info: http://dev.mysql.com/doc/refman/5.5/en/explain-output.html

But why do you have a table with 25000 rows in which all rows have the same values for column a and b? And if that's strictly necessary: why do you have "a=... AND b=..." in the query when you know that all rows will match this condition?

Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com