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 table variable.
B.
Use a temporary table.
C.
Split the update operation into small batches.
D.
Use the NOLOCK optimizer hint and use a single transaction.