Hints
DB2 Hints
| CATEGORY | HINT | 8.0 | 9.0 | Info | Status |
| Command | SET OPTIMIZATION LEVEL | For top-level SELECT statements only | |||
| Clause | optimize for <n> rows | For top-level SELECT statements only | |||
| Clause | fetch first <n> rows only | For SELECT statements only |
| CATEGORY | HINT | 8.0 | 9.0 | Info | Status |
| Command | SET OPTIMIZATION LEVEL | For top-level SELECT statements only | |||
| Clause | optimize for <n> rows | For top-level SELECT statements only | |||
| Clause | fetch first <n> rows only | For SELECT statements only |