MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: LEFT JOIN Optimization
Posted by: KimSeong Loh
Date: August 21, 2007 06:45PM

Logically WHERE is applied after JOIN, but if it can be done earlier to prune the result, the optimiser may do so, but result wise will be the same as applying WHERE after JOIN.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
LEFT JOIN Optimization
7778
Ram R
August 21, 2007 03:04PM
Re: LEFT JOIN Optimization
3811
KimSeong Loh
August 21, 2007 06:45PM
Re: LEFT JOIN Optimization
3360
Ram R
August 21, 2007 11:32PM
Re: LEFT JOIN Optimization
3308
KimSeong Loh
August 29, 2007 07:19PM
Re: LEFT JOIN Optimization
3071
Adrian Chapela Cordeiro
August 29, 2007 03:55AM


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.