![ECHO option [DBISQL]](arrow-left.gif){kind=icon}
Allows optimizer to estimate thread allowance for each table that contains invariant predicates.
ON, OFF
OFF
Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
The IQ optimizer assigns a thread quota to each table that contains invariant predicates based on the row counts after high selectivity filters. This algorithm provides better thread allocation, which prevents the server from running out of threads.
