Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Jun 2001 @ 17:52:46 GMT


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


Subj:   Re: Exchange Rate Join Problems
 
From:   Rajiv Devulapalli

I have found that, in my environment, if a table has more than 1000 rows, the optimizer almost never duplicates the rows on all amps. It seems to be the same in your case. So, I agree with the suggestion below, that if you can

a) remove unnecessary history from the exch. rate table

OR

b) create a separate processing table(derived maybe?) with only the 150 relevant rows and use that in your join, the optimizer will duplicate the small table on all amps, and that should perform quite well.

Rajiv Devulapalli GAP Inc.,



     
  <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