Hello,
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 does it show if you do a
show indexes from actions
-----------------------
If you are sure the optimizer is wrong, you can FORCE it to use an index.
The USE INDEX option only suggests an index to mysql.
SELECT * FROM actions FORCE INDEX (datum) ORDER BY datum
And see if it makes a speed difference. Most often, if MySql didn't use it, then it won't help but I'm sure it can be wrong once in a while.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
