![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 17 Apr 2007 @ 21:52:34 GMT
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
| |