Users frequently update millions of rows in a table at a time. Users report that it takes a long
time to update the rows. You need to recommend a solution to reduce the time it takes to
update the rows. The solution must be developed in the minimum amount of time. What
should you do?
A.
Use a temporary table.
B.
Split the update operation into small batches.
C.
Use a table variable.
D.
Use the NOLOCK optimizer hint and use a single transaction.