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: July 31, 2007 05:55AM

IMHO if U use LEFT JOIN it is nothing to optimize. MySQL should select all rows in `img` table and concatinate with other tables.

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


Subject
Views
Written By
Posted
Need some help to optimize a query with multiple JOIN
6844
Jean-Baptiste ANNE
July 30, 2007 01:42PM
Re: Need some help to optimize a query with multiple JOIN
3015
Sergey Belov
July 31, 2007 05:55AM
Re: Need some help to optimize a query with multiple JOIN
2881
Jean-Baptiste ANNE
July 31, 2007 10:20AM
Re: Need some help to optimize a query with multiple JOIN
2851
Sergey Belov
August 01, 2007 01:12AM
Re: Need some help to optimize a query with multiple JOIN
3023
Jean-Baptiste ANNE
August 01, 2007 07:58AM
Re: Need some help to optimize a query with multiple JOIN
3071
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.