Posted by --CELKO-- on 07/02/07 13:44

>> However, I think using LEFT JOINs instead of INNER JOINs is not the proper solution.<<

The OUTER JOINS have to be executed in left to right order, so that is
probably what the optimizer will do first. I think that detecting
when an OUTER JOIN can be replaced by an INNER JOIN so that the query
can be re-ordered would be very hard and probably impossible in the
general case.

• Next in forum: Re: Combining Values
• Prev in forum: Re: Performance between Standard Join and Inner Join
• Thread view: Re: Performance between Standard Join and Inner Join

[Reply to this message]