INSERTS INTO A TABLE CREATED WITH NOLOGGING
592323May 7 2008 — edited May 7 2008Hi,
There is a job which loads a table everyday with 7 million records that takes 40 min to complete.The job does the following things:
Truncate the table
alter table disable constraints
insert into the table select * from 100 tables;
alter table enable constraints;
Since it is taking a lot of time,the table is altered with nologging.
so truncate,disable constraints and insert is finishing in 14 min but for enabling the constraints it is taking the rest of the time and the total duration is almost the same.So any other options to make this job run faster using the above method
Thanks.