MySQL Forums
Forum List  »  Optimizer & Parser

Re: Need some help to optimize a query with multiple JOIN
Posted by: KimSeong Loh
Date: August 05, 2007 01:03AM

First, get rid of the unnecessary LEFT JOIN and change them into INNER JOIN, you can at least convert 2 LEFT JOIN into INNER JOIN.

Do you know the difference between LEFT JOIN and INNER JOIN?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need some help to optimize a query with multiple JOIN
2952
August 05, 2007 01:03AM


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.