One thing I don't understand is what MySQL tried to do first. Why did MySQL chose co.name as a key?
On 3/3/07, Filip Krejci <[EMAIL PROTECTED]> wrote:
> 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 <[EMAIL PROTECTED]> LINUX-All you need -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]