Re: [GENERAL] Yet Another newbie not understanding why an index isn't used

[Michal Maruška]

> hlt=> EXPLAIN SELECT * FROM hltdata ORDER BY stmp, id LIMIT 10;


If I remember well, the order of the index attributes must be the same as 
... in the query which should use it: try "id, stmp"