XML schema for general optimization guidelines

The generalRequest group defines guidelines that are not specific to a particular phase of the optimization process. The guidelines can be used to change the optimizer search space.

<!--************************************************************************************* --> \
<!-- Choices of general request elements.                                                 --> \
<!-- REOPT can be used to override the setting of the REOPT bind option.                  --> \
<!-- DPFXMLMOVEMENT can be used to affect the optimizer's plan when moving XML documents  --> \
<!-- between database partitions. The allowed value can be REFERENCE or COMBINATION. The  --> \
<!-- default value is NONE.                                                               --> \
<!--************************************************************************************* --> \
<xs:group name="generalRequest"> 
      <xs:element name="REOPT" type="reoptType" minOccurs="0" maxOccurs="1"/>
      <xs:element name="DEGREE" type="degreeType" minOccurs="0" maxOccurs="1"/>
      <xs:element name="QRYOPT" type="qryoptType" minOccurs="0" maxOccurs="1"/>
      <xs:element name="RTS" type="rtsType" minOccurs="0" maxOccurs="1"/>
      <xs:element name="DPFXMLMOVEMENT" type="dpfXMLMovementType" minOccurs="0" maxOccurs="1"/>
      <xs:element name="REGISTRY" type="registryType" minOccurs="0" maxOccurs="1"/>

General optimization guidelines can be specified at both the global and statement levels. The description and syntax of general optimization guideline elements is the same for both global optimization guidelines and statement-level optimization guidelines.


General request elements define general optimization guidelines, which affect the optimization search space. Affecting the optimization search space can affect the applicability of rewrite and cost-based optimization guidelines.