Page History
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. |
Scroll pdf ignore |
---|
Automate SQL tuning and profiling with DB Optimizer. Learn more > > |