Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

which one is better

ASK_NMNov 25 2011 — edited Nov 29 2011
When we want update more than 100 million records, using bulk update is better or merge statement is better, ? when i used bulk statement it took 24 sec to update 10,000 records and when i used merge it took only 89 milli seconds, what is the difference between them ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2011
Added on Nov 25 2011
10 comments
190 views