Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 16:56:33 GMT

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

As I understand it, the primary index of a PPI table can only be unique if and only if the partition expression is part of the primary index (PI). If you partition on a field that is not part of the PI, even it the PI in the non-partitioned table is unique then you must define the new PI as a NUPI in the partitioned table.

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