The following table highlights SQL hints based on IBM DB2 hints optimization.

CategoryHintNotes
CommandSET OPTIMIZATION LEVELFor top-level SELECT statements only.
Clauseoptimize for <n> rowsFor top-level SELECT statements only.
Clausefetch first <n> rows onlyFor SELECT statements only.



IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal