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.
