Database options that control resources are called resource
governors. Set database options using the SET OPTION
statement.
- 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.