QRYOPT requests
The QRYOPT general request element can be used to override the setting of the QUERYOPT bind parameter, the value of the dft_queryopt database configuration parameter, or the result of a previous SET CURRENT QUERY OPTIMIZATION statement. It is defined by the complex type qryoptType.
XML Schema
<xs:complexType name="qryoptType">
<xs:attribute name="VALUE" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="0"/>
<xs:enumeration value="1"/>
<xs:enumeration value="2"/>
<xs:enumeration value="3"/>
<xs:enumeration value="5"/>
<xs:enumeration value="7"/>
<xs:enumeration value="9"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
Description
The QRYOPT general request element
has a required VALUE attribute that specifies the setting of the QUERYOPT
option. The attribute can take any of the following values: 0, 1,
2, 3, 5, 7, or 9. For detailed information about what these values
represent, see Optimization classes
.