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
