|
|
Archives of the TeradataForum
Message Posted: Sat, 03 Oct 2015 @ 19:56:27 GMT
Subj: | | Re: Dropping Primary Index |
|
From: | | Arunachalam, Sankar T. |
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
| |