Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 09:45:59 GMT

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

Hi,

In some cases it would be useful to be able to specify that a table data is duplicated across all AMP's.

Maybe via a modification to the CREATE TABLE command.

This would be very useful to ensure that when a large table / small table join is performed, that it is done via the duplicated data, and not requiring redistribution of the large table.

Regards

Matthew Winter

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