Which would be faster method of removing a partition?
656919Jan 30 2010 — edited Jan 31 2010I have a table partitioned on a CREATE_DATE column, so daily partitions. I have a job that nightly trims off the 'old' partitions and was wondering which method would be faster:
1. ALTER TABLE FLOW_COMPLETION_RECORD_PART DROP PARTITION D2010019_FCR UPDATE GLOBAL INDEXES;
or
2.
ALTER TABLE FLOW_COMPLETION_RECORD_PART TRUNCATE PARTITION D2010019_FCR ;
ALTER TABLE FLOW_COMPLETION_RECORD_PART DROP PARTITION D2010019_FCR UPDATE GLOBAL INDEXES;
There are about 1.5 million records in a partition, all indexes are global. I am doing step 1 now and it takes much longer than I would like. Is there a way I can specify nologging or such on the 'DROP PARTITION' command?
Thanks,
M