Archives of the TeradataForum

Message Posted: Mon, 19 Jan 2004 @ 09:52:43 GMT

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

Duplicate - is creating a replica of the spool(intermediate resultant set of rows) on all the amps(/participating amps).

redistribute - this is done when the a column participating in a where clause is something other than the primary index. In such case that non- primary index column is hashed and that(those) row(s) are hash re-distributed so that they reach an amp which matches with the newly created hash.

Narayan

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