Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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

  <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: 15 Jun 2023