Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 17 Apr 2007 @ 21:52:34 GMT


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


Subj:   Alter Partition
 
From:   Jeyaraj, Rameshkumar

Hi,

Is there any difference in the following alter statement.

Could you please let me know the correct syntax and performance benefits?

     Delete Partition: COL_NUM BETWEEN 16238 AND 16251
     -------------------------------------------------

     ALTER TABLE TEMP.TEST1
           MODIFY PRIMARY INDEX TABLE_PI
           PARTITION BY RANGE_N (COL_NUM BETWEEN 16252 AND 16294 EACH 1)
               WITH DELETE;


     ALTER TABLE TEMP.TEST1
           REVALIDATE PRIMARY INDEX T_PI
           PARTITION BY RANGE_N (COL_NUM BETWEEN 16252 AND 16294 EACH 1)
               WITH DELETE;


     Alter table TEMP.TEST1
           MODIFY PRIMARY INDEX T_PI
           DROP RANGE COL_NUM BETWEEN 16238 AND 16251 EACH 1
           ADD RANGE COL_NUM BETWEEN 16252 AND 16294 EACH INTERVAL 1
               WITH DELETE;

Regards,

Ram



     
  <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: 27 Dec 2016