tesla764
asked on
We need to update every row in a busy production OLTP database table that contains approximately 50 million rows
We need to update every row in a busy production OLTP database table that contains approximately 50 million rows. Any suggestionson how we may approach this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
option 1:
set rowcount 1000
update mytable
set value = @value.
where value <> @value
option 2:
do this in small controlled chunks.
use the PK to control the rows you retrive and update every batch and move forward.