Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2004 @ 13:51:46 GMT


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


Subj:   Re: How to add a partitioned index
 
From:   Christian Schiefer

Hi,

1.) you can only partition the PI --> No way to add a PI to a table ;)

2.) Once the table has a PPI, you can modify it.


Sample:

     alter table T1 modify primary index add range ......;
     alter table T1 modify primary index delete range .....;

Christian



     
  <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