cxscheid
asked on
Oracle Update: Improving speed/resource usage for a large number of updates
Hi,
I have to do a simple update but on a lot of rows. The update statement for each of the 4 million+ rows looks like this:
update table1 set col1= 'xyz' where col2 = 'abc';
Each row has a different non-predictable set of values.
I'm concerned about the speed and resources being used when I execute this statement 4 mil. times. I guess throwing in some 'commit;' statements would help.
But is there a better way to do this?
Thanks!
I have to do a simple update but on a lot of rows. The update statement for each of the 4 million+ rows looks like this:
update table1 set col1= 'xyz' where col2 = 'abc';
Each row has a different non-predictable set of values.
I'm concerned about the speed and resources being used when I execute this statement 4 mil. times. I guess throwing in some 'commit;' statements would help.
But is there a better way to do this?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.