![Dropping join indexes on a write server [CR 385317]](arrow-left.gif){kind=icon}
![LOAD_ZEROLENGTH_ASNULL option added [CR 383943]](arrow-right.gif){kind=icon}
Sybase IQ 12.6 featured a new algorithm to avoid running out of threads. When the algorithm is used (the default), the IQ optimizer assigns a thread quota to each table that contains invariant predicates, based on the row counts after high selectivity filters.
In ESD #3, the ENABLE_THREAD_ALLOWANCE option was added to let users control when the optimizer uses the algorithm. The option may be set temporary, for an individual connection, or for the PUBLIC group. It may be set ON or OFF, and takes effect immediately. The default is now OFF.
