Updating thousands of rows

When you update large volumes of data, consider certain recommended actions to increase concurrency.

About this task

Question: Are there any special techniques for updating large volumes of data?

Answer: Yes. When updating large volumes of data using a cursor, you can minimize the amount of time that you hold locks on the data by declaring the cursor with the HOLD option and by issuing commits frequently.