Quote:
Originally posted by tamilselvan
This will ensure that the minimum redo/undo info is generated againt any DML on that table.
............
This method is faster than any other method I foresee.
In the absense of Jurij, I will take the liberty of pointing out that setting the table to NOLOGGING mode WILL NOT HAVE any performance gain FOR ANY DELETE statement issued against it.
Just to put the record straight, only the following will benefit from NOLOGGING:
alter table...move partition
alter table...split partition
alter index...split partition
alter index...rebuild
alter index...rebuild partition
create table...as select
create index
direct load with SQL*Loader
direct load INSERT
-amar
