DB2 Version 9.7 for Linux, UNIX, and Windows

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

db2dsdriver.cfg configuration syntax

<parameter name="QueryOptimizationLevel" value="integer value from 0 to 9"/>

Default setting:

No SET CURRENT QUERY OPTIMIZATION statement issued.

Usage notes:

If this option is set, a DB2® application issues the following SQL statement after a successful connection:

 
SET CURRENT QUERY OPTIMIZATION positive number

This specifies the query optimization level at which the optimizer should operate the SQL queries.