Neoview Control Query Default (CQD) Reference Guide (R2.5)

The optimizer generates and considers plans where the rows are
inserted, updated, or deleted in clustering key order.
‘ON’
The optimizer does not generate plans where the rows must be
inserted, updated, or deleted in clustering key order.
‘OFF’
The default value is ‘ON’.
Values
Inserting, updating or deleting rows in the clustering key order is most efficient and highly
recommended. Turning this CQD OFF may result in saving the data sorting cost but at the
expense of having less efficient random I/O Insert/Update/Delete operations.
If you know that he data is already sorted in clustering key order, or is mostly in clustering
key order, so that it would not result in random I/O, you could set this CQD to OFF.
Usage
Not applicableProduction usage
If turned OFF, the system may perform large number of inefficient Random I/Os when
performing Insert/Update/Delete operations.
Impact
QueryLevel
Not applicableConflicts/Synergies
Not applicableAddressing the real
problem
Neoview Release 1.0Introduced in release
Not applicableDeprecated in release
UPD_ORDERED 55