Re: A simple 2 table query gets very slow when using ORDER BY

[Filip Krejci]

Hi,

if your selectivity is very low, try to use multiple index on e2s(co_id, 
mod_time) and force this index in query.

Filip



employees2skills:
INSERT INTO employees2skills SELECT id, 1, 2, NOW() FROM employees;
# Yes, 1000000 have same skill_id, co_id, and even mod_time.
# selectivity is extreamly low



--
Filip Krejci <[EMAIL PROTECTED]>

Vini, vidi, Linux!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]