Archives of the TeradataForum

Message Posted: Thu, 08 Mar 2012 @ 13:41:59 GMT

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

It is possible for NUPI (non-unique primary index). You can add a partitioning column that is not a part of the primary index.

However for UPI (unique primary index), the partitioning column has to be a part of the key. This is so that the RDBMS only looks on the current target AMP to check for duplicates.

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