Archives of the TeradataForum

Message Posted: Thu, 27 Apr 2006 @ 18:55:10 GMT

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

Naveen,

I understand but in TD to minimize the data movement across AMPs you have to define an appropriate PI. For example, suppose there is an one-to- many relationship between tables ITEM and ITEM_LINE. PK of these tables may be different. But I can have PI of these two tables same to keep them in same AMP for join. i.e ITEM or ITEM_LINE will not be re-distributed across the AMPs each time you join them. Join will happen locally on each AMP as they have same PI.

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