Database options that control resources are called resource
governors.
You can set database options using the SET
OPTION statement.
Resources You Can Manage
- CURSOR_WINDOW_ROWS – defines the number of cursor rows to buffer.
- MAX_CARTESIAN_RESULT – limits the number of result rows from a query containing a Cartesian
join.
- MAX_IQ_THREADS_PER_CONNECTION – sets the number of processing threads available to a connection for use
in IQ operations
- TEMP_CACHE_MEMORY_MB – sets the size of the cache for the SAP Sybase IQ
temporary store. (The server option -iqtc is the
recommended way to set the temp cache size.)
- QUERY_TEMP_SPACE_LIMIT – limits the amount of temporary dbspace available to any one query.
- QUERY_ROWS_RETURNED_LIMIT – tells the query optimizer to reject queries that might consume too many
resources. If the optimizer estimates that the result set from the query
will exceed the value of this option, the optimizer rejects the query
and returns an error message.
The following database options affect the engine, but have limited impact on
SAP Sybase IQ:
- JAVA_HEAP_SIZE – sets the maximum size (in bytes) of the memory allocated to Java
applications on a per connection basis.
- MAX_CURSOR_COUNT – limits the number of cursors for a connection.
- MAX_STATEMENT_COUNT – limits the number of prepared statements for a connection.
Database option settings are not inherited through the role structure.