SQL optimization options
You set the Optimization options on the on the Editor Options
(2 of 8) panel to specify a OPTIMIZE FOR nnn ROWS clause
in the SQL statement used to retrieve data from Db2®.
Effect of SQL optimization options describes the behavior for various combinations of options:
| Use row count value | Row count | Optimize for … Rows | Behavior |
|---|---|---|---|
| Not selected | 0 | 0 | No clause |
| Not selected | 0 | nnn | OPTIMIZE FOR nnn ROWS appended |
| Not selected | nnn | 0 | No clause |
| Not selected | nnn | mmm | OPTIMIZE FOR mmm ROWS appended |
| Selected | 0 | 0 | No clause |
| Selected | 0 | nnn | OPTIMIZE FOR nnn ROWS appended |
| Selected | nnn | 0 | OPTIMIZE FOR nnn ROWS appended |
| Selected | nnn | mmm | OPTIMIZE FOR nnn ROWS appended |
Related references