Sunday, 22 April 2012

Can you improve the performance of SQL*Loader? | Oracle DBA

You can use direct path load to improve the performance.
Indexes and constraints make inserts slow. Removing indexes and constraints improve performance of inserts; and therefore, of SQL*Loader.

No comments: