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.