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

[Filip Krejci]

> SELECT *
> FROM employees2skills e2s FORCE INDEX (mod_time )
>  INNER JOIN companies c ON c.id = e2s.co_id
> ORDER BY e2s.mod_time limit 5;
Yes, this query will be probably the best.

This go through mod_time index (which is already sorted) from begin and 
try to join companies.
When row count achieve limit, joining is stopped and result is send.


-- 
Filip Krejci <krejcif@stripped>

LINUX-All you need