You develop a stored procedure for a wholesale glass manufacturing company. The stored procedure uses a cursor to read all row-based combinations of the following tables:

You observe that the stored procedure returns results very slowly.

You need to improve the execution speed of the stored procedure.

Which cursor type should you use?

A. GLOBAL FORWARD_ONLY

B. LOCAL FAST_FORWARD

C. LOCAL STATIC READ_ONLY FORWARD_ONLY

D. GLOBAL STATIC

Explanation:

FAST_FORWARD specifies a FORWARD_ONLY, READ_ONLY cursor with performance optimizations enabled.

References: https://msdn.microsoft.com/en-us/library/ms180169.aspx