Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 25 Nov 2002 @ 13:03:50 GMT


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


Subj:   Unnecessary Re-Distributions
 
From:   Claybourne Barrineau

All,

I have a case where I need to build a summary table with data stored at the 'month' level from a table with data stored at the 'day' level. The NUPI of these 2 tables are identical (neither involve the period dimension) and no joins are involved in this aggregation. Teradata performs this aggregation AMP locally then re-distributes the data to all AMPs. This re-distribution step is unnecessary since the 2 tables have the same NUPI. I noticed that the optimizer does this with both physical tables and AJIs.

Shouldn't the optimizer be aware of the fact that the source and destination tables have the same NUPI, and therefore, not re-distribute the data?


Thanks,

Claybourne Barrineau



     
  <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