Alexandre Benson Smith wrote:

>
> If I got it right you are saying that the process order of the table on
> an outer join are just relevant to the two involved tables and has no
> significance to the other ?

OK, we were both confused. I missed a left join in your first example,
which was the cause of undesirable plan. You're completely right about
putting outer joins last. If that fits the logic of the query, it gives
the optimizer the best chance at finding a good plan.

Regards,


Ann