----- Original Message ----- > From: "Sergei Petrunia" <pser...@askmonty.org> > > Create index on (importance, company_id) (or > (company_id,importance), should > not matter). When that index is present, the query should use ref > access on it using both key parts (if by some crazy reason it doesn't, use > FORCE > INDEX to make it to). This way, you will be scanning as few rows as possible.
Umm... It might just be a matter of cardinality? :-) While the optimizer can be wrong at times (and it's certainly worth checking that) it does usually pick the best choices. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org