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>>