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.
To use OPTIMIZESPCURSORS, you must set DBMAN=ADO.
|Used at compile time:
|Behavior at run time:
Scope - OpenESQL SQL Compiler Directive Options for more information.