Re: Which is better, Load/Delete/Insert or Update?
You will have to realize that other applications, if any, in the environment will decrease in performance and decrease the performance of IMPORT ..
Well, if you have other applications running during this job, have a low commitcount in the IMPORT to ensure that IMPORT doesn't escalate to tablelevel locking and prevent other applications from accessing the data ....
Originally posted by sathyaram_s
Assuming your PROD tables have primary keys and the primary keys are not updated , you can use IMPORT with INSERT_UPDATE option ... That is an easy way of doing your stuff ....