to make an insert run faster
592323May 20 2008 — edited May 21 2008Hi,
There is an sql statement which inserts 10 million records everyday and is taking 1.5 hours to run.The table is truncated and the data is loaded everyday.The constraints are disabled before inserting the records.The following options are tried
table created in nologging
truncate table with reuse storage
diable constraints
insert with append hint
enable constraints
table created in nologging
truncate table with resue storage
drop constraint
insert with append hint
add constraint
But there is no significance improvement in the timings of the load.Can anyone assist in this?