QueryOptimizationLevel IBM data server driver configuration keyword
Sets the query optimization level.
- Equivalent CLI keyword
- DB2Optimization
- Equivalent IBM® data server provider for .NET connection string keyword
- N/A
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="QueryOptimizationLevel" value="integer value from 0 to 9"/>
- Default setting:
- No SET CURRENT QUERY OPTIMIZATION statement issued.
- Usage notes:
- If the QueryOptimizationLevel keyword is set, the client issues the following SQL statement after a successful connection:
SET CURRENT QUERY OPTIMIZATION positive number
The QueryOptimizationLevel value specifies the query optimization level for the SQL queries.