Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 10:31:37 GMT


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


Subj:   Re: Duplicate Table across all AMPs
 
From:   Claybourne Barrineau

Matthew,

1) We've found that putting a small table on a single AMP (via a NUPI on a constant value which can be referenced in a view of the base table), in most cases, will encourage the optimizer to duplicate a small table to all AMPs.

2) If this doesn't work, depending on your situation, you may want to consider collecting stats on the small table while it is empty, then populate the table. This approach works fine when only a few tables are involved; however, if many tables are involved, this probably won't be a safe approach.

3) Finally, make sure that the hash join feature is enabled (for star schemas, this is a must.) This will result in fewer redistributions of the LT.


Thanks,

Clay

Claybourne L. Barrineau
Senior Application DBA
Coca-Cola Enterprises, 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