Subquery-to-join query rewrite requests

The SUBQ2JOIN query rewrite request element can be used to enable or disable the subquery-to-join rewrite transformation. It can be specified as a statement-level optimization guideline only. The SUBQ2JOIN request element is defined by the complex type subqueryToJoinType.

XML Schema

   <xs:complexType name="subqueryToJoinType">
      <xs:attribute name="OPTION" type="optionType" use="optional" default="ENABLE"/>
   </xs:complexType>

Description

The SUBQ2JOIN query rewrite request element has one optional attribute and no sub-elements. The OPTION attribute can take the value ENABLE (default) or DISABLE.