MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Need some help to optimize a query with multiple JOIN
Posted by: Sergey Belov
Date: August 01, 2007 01:12AM

Do you realy need LEFT JOIN? If so, you will nothing to do. You can try reorganize the tables order.

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


Subject
Views
Written By
Posted
Need some help to optimize a query with multiple JOIN
6565
Jean-Baptiste ANNE
July 30, 2007 01:42PM
Re: Need some help to optimize a query with multiple JOIN
2877
Sergey Belov
July 31, 2007 05:55AM
Re: Need some help to optimize a query with multiple JOIN
2771
Jean-Baptiste ANNE
July 31, 2007 10:20AM
Re: Need some help to optimize a query with multiple JOIN
2752
Sergey Belov
August 01, 2007 01:12AM
Re: Need some help to optimize a query with multiple JOIN
2898
Jean-Baptiste ANNE
August 01, 2007 07:58AM
Re: Need some help to optimize a query with multiple JOIN
2956
KimSeong Loh
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.