MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimiztion of LEFT JOIN and LIMIT
Posted by: Sopace Sopcae
Date: October 05, 2010 02:21PM

Some updating:

SELECT
*
FROM
(
SELECT * FROM tableA ORDER BY a_id LIMIT 100
) AS a
LEFT JOIN tableB AS b ON b.a_id = a.a_id
LEFT JOIN tableC AS c ON c.c_id = b.c_id
LEFT JOIN tableD AS d ON d.b_id = b.b_id

Options: ReplyQuote


Subject
Views
Written By
Posted
3607
October 05, 2010 01:33PM
Re: Optimiztion of LEFT JOIN and LIMIT
1439
October 05, 2010 02:21PM
1961
October 06, 2010 09:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.