DB2 Version 9.7 for Linux, UNIX, and Windows

OptimizeForNRows CLI/ODBC configuration keyword

Appends 'OPTIMIZE FOR n ROWS' clause to every select statement.

db2cli.ini keyword syntax:
OptimizeForNRows = integer
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.