DEGREE requests

The DEGREE general request element can be used to override the setting of the DEGREE bind parameter, the value of the dft_degree database configuration parameter, or the result of a previous SET CURRENT DEGREE statement.

The DEGREE general request element is only considered if the instance is configured for intrapartition parallelism; otherwise, a warning is returned. It is defined by the complex type degreeType.

XML Schema

   <xs:simpleType name="intStringType">
      <xs:union>
         <xs:simpleType>
            <xs:restriction base="xs:integer">
               <xs:minInclusive value="1"></xs:minInclusive>
               <xs:maxInclusive value="32767"></xs:maxInclusive>
            </xs:restriction>
         </xs:simpleType>
         <xs:simpleType>
            <xs:restriction base="xs:string">
               <xs:enumeration value="ANY"/>
               <xs:enumeration value="-1"/>
            </xs:restriction>
         </xs:simpleType>
      </xs:union>
   </xs:simpleType>

   <xs:complexType name="degreeType">
      <xs:attribute name="VALUE"
         type="intStringType"></xs:attribute>
   </xs:complexType>

Description

The DEGREE general request element has a required VALUE attribute that specifies the setting of the DEGREE option. The attribute can take an integer value from 1 to 32 767 or the string value -1 or ANY. The value -1 (or ANY) specifies that the degree of parallelism is to be determined by the data server. A value of 1 specifies that the query should not use intrapartition parallelism.