Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 03 Jun 2011 @ 13:27:41 GMT

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

Subj:   Re: Product Join: Duplicating large table
From:   Diehl, Robert

I believe the only case it would try to duplicate a large table is when statistics are missing or stale. The interpreter decides that the table is not actually large and duplicates the large table. This can be corrected by collecting missing or stale statistics.

NOTE: duplication of a table across all amps is not the same as redistribution. Duplication is a full copy of the table across all amps. Redistribution is moving rows to different amps.


Robert Diehl
Travelocity Data Warehouse DBA

  <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: 15 Jun 2023