Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Pls Explain the Explain Plan
 
From:   Chaithanya R Abbaraju

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016