Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 17:57:37 GMT

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

If you want PPI and Unique Primary Index, the partition column should be part of the primary index. You can not alter a non-empty table. You should create a new table by including your partition column(DATE in your example) in the Unique Primary Index, and insert the data from the old table.

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