yash_08031983 wrote:Answer depends upon Oracle version.
I trying to under stand the explain plan , I read the link
Example 3: The inefficiency is coming from the wrong join order, where the bigger row source is taken as the driving table.
Hmmm. Not really in all cases.
What matters is the order in which a join is executed, not the order in which you specify join conditions