Manjula Kutty <[EMAIL PROTECTED]> writes: > Thanks for the reply Mamta. But the thing is I could not find the > specic join order in the runstime statistics plan. May be I don't know > how ot read it? In the given plan did you find anything about the join > order??
Hi Manjula, I think the join order is T1, T3. Under Hash Join ResultSet, the plan says that the left result set is a Distinct Scan ResultSet for T1, and the right result set is a Hash Table ResultSet whose source result set is a Distinct Scan ResultSet for T3. -- Knut Anders
