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.