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.