You have a stored procedure that uses a cursor. The stored procedure updates several
related tables. You discover that the stored procedure runs slowly and uses a significant
amount of resources on the database server. You need to recommend changes to the
stored procedure to meet the following requirements: ·Minimize execution time ·Minimize
development effort ·Minimize server resource requirements What should you recommend?
A.
Change the cursor to a dynamic cursor.
B.
Change the cursor to a client-side cursor.
C.
Rewrite the cursor by using set-based operations.
D.
Rewrite the cursor by using recursive CLR stored procedure.