Corin Langosch wrote:
> 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.