Archives of the TeradataForum
Message Posted: Sun, 04 Oct 2015 @ 08:14:25 GMT
| Subj: | | Re: Dropping Primary Index |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Sunday, October 04, 2015 00:43 -->
Sankar Arunachalam wrote:
| | 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 | |
So In other words I can not insert data into a table after the PI is dropped. Or I have to recreate the table with NO PRIMARY INDEX clause.
Is this correct ?
If a table is built with No Primary Index clause, is it possible to add a PI to this table with data in it ?
Please advise.
| 
