OptimizeForNRows CLI/ODBC and IBM data server driver configuration keyword
Appends 'OPTIMIZE FOR n ROWS' clause to every select statement.
- db2cli.ini keyword syntax:
- OptimizeForNRows = integer
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="OptimizeForNRows" value="integer"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- The clause is not appended.
- Equivalent statement attribute:
- SQL_ATTR_OPTIMIZE_FOR_NROWS
- Usage notes:
This option will append the "OPTIMIZE FOR n ROWS" clause to every select statement, where n is an integer larger than 0. If set to 0 (the default) this clause will not be appended.