Archives of the TeradataForum

Message Posted: Thu, 14 May 2009 @ 09:10:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

As per my knowledge the SQL will be executing from top to bottom but when i see the Explain Plan its not as per the SQL flow top to bottom like i have a submited an SQL

     Sel * from
     TableA
     inner join
     TableB
     inner join
     TableC
     left outer join
     TableD
     left outer join
     TableE
     left outer join
     TableF

in the explain its showing as the PE is picking TableC LJ with TableD and then IJ with TableA .... in some different manner

can any one Explain the Explain Plan?

Thanks and Regards

Rahul Abbaraju

	<Prev	Next>		<<First	<Prev	Next>	Last>>