Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 04 Oct 2015 @ 08:14:25 GMT

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

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020