Parameter
dbs/db4/nqe_optimize_method
Short text
Optimization method used by the NQE
Parameter Description
The new query engine (NQE) introduced with V5R2 has the option to optimize an SQL statement to return all rows of a result set immediately (like the SAP system works), instead of “a screen at a time”.
If the parameter is set to ‘A’, all statements are optimized with the new optimization goal, if it is set to ‘O’, the database makes the decision whether that is suitable (recommended).
For more information, see SAP Note 705888.
Default Value
O
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
F — First I/O (“screen at a time”)
A — All I/O
O — Optimize (whenever suitable)
