For SQL CLR stored procedures, opens forward read-only cursors as firehose cursors, and when subsequent cursors are opened, reads the remainder of the result set into memory to optimize performance.
Restriction: Applies to .NET applications only.
Syntax:
OPTIMIZESPCURSORS
Dependencies:
To use OPTIMIZESPCURSORS, you must set DBMAN=ADO.
Scope:
| Used at compile time:
|
Yes
|
| Behavior at run time:
|
Source file
|
See
Scope - OpenESQL SQL Compiler Directive Options and
Scope - HCOSS SQL Compiler Directive Options for more information.