The following table highlights SQL hints based on IBM DB2 hints optimization.
| Category | Hint | Notes |
|---|---|---|
| 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. |