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.
