A
Anonymous
Guest
I've noticed that MYSQL is not using indexes when the operators "<" or ">" are used in the SELECT query;
For example:
SELECT firstname
FROM users
WHERE birthyear < 1969
Now, birthyear is of type "int" and is indexed. However the EXPLAIN statement shows that all rows are examined!
Can anyone explain why?
For example:
SELECT firstname
FROM users
WHERE birthyear < 1969
Now, birthyear is of type "int" and is indexed. However the EXPLAIN statement shows that all rows are examined!
Can anyone explain why?