sql loader time
Posted on 2006-06-21
I am using sql loader to load a table having 10 columns.
data is by month and each month has approx 5 million rows.
It is taking 2.5 hours each to load the first and second month
With 3rd month time starts increasing by 1 hour which means 3rd month takes 3.5 hour fourth minth takes 4.5 hours.
Basically deterioration in the loading time.
Can anybody tell me why is this happeneing and how can this be avoided.
Also, I think it has anyhthing to do with index in the table. Every row loaded has to be updated in the index also.
If yes than how can this be avoided.
Thanks in advance