ORDER BY ... LIMIT

[Ed Mazur]

Hi all,

I'm having some trouble optimizing a SELECT statement that uses ORDER BY ... LIMIT:

EXPLAIN
SELECT *
FROM bots_levels
ORDER BY date DESC
LIMIT 200;

I created an index on the date column, but this query still ends up going through all ~140,000 rows. I browsed through the documentation and looked at a tutorial on optimizing ORDER BY ... LIMIT queries, but both were to no avail.

Ed