|Used at compile time:
|Behavior at run time:
See Scope - OpenESQL SQL Compiler Directive Options for more information.
For SQL Server connections, a forward-only read-only non-hold cursor always uses a firehose cursor with no prefetching. There is no benefit in prefetching firehose cursors because the server streams the result set to the client for firehose cursors.