Archives of the TeradataForum

Message Posted: Sat, 03 Oct 2015 @ 19:56:27 GMT

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

Primary index is not a physical sub structure independent of the table data. The columns of the primary index are used to distribute the table data across all the amps. So the only way you alter or drop the primary index is by rebuilding the table. Alter Primary index is allowed on an empty table because there's no data to redistribute from old PI to the new PI. Hope this helps

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