Archives of the TeradataForum

Message Posted: Fri, 02 Jul 2004 @ 12:10:45 GMT

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

Since the join involves equality condition on columns other than the PI (Here SOS_SEQ_ID), Teradata cannot avoid redistribution/duplication. Merge join can also involve a duplication if the optimizer decides that it is less costly to duplicate a smaller table on all AMPs than redistribute the larger table.

Sanjaya

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