OptimizeForNRows CLI/ODBC configuration keyword

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.