Hi Corin, As I said - I don't have the slightest idea about the MySQL optimizer, but I'm trying to learn.
> thanks for your fast reply. even when i use > EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10 > the key isn't used. the query takes about 2s :-( What if you do: SELECT ... WHERE DATUM < some-value With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]