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.

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA