Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 18:00:29 GMT


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


Subj:   Regarding Explain Plan: .READ
 
From:   Pothula, Srinivas

Hi All,

Could anyone help me when <database>.READ will be pulled in the Explain plan of the query

Please find some of the text of the explain plan
------------------------------------------------

We do an all-AMPs JOIN step from Spool 6 (Last Use) by way of an all-rows scan, which is joined to <database>.READ by way of an all-rows scan with no residual conditions. Spool 6 and database>.READ are joined using a product join, with a join condition of ("(1=1)"). The result goes into Spool 12 (all_amps), which is duplicated on all AMPs into 18 hash join partitions


Thanks,

Srinivas.



     
  <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