NOT-IN-to-anti-join query rewrite requests

The NOTIN2AJ query rewrite request element can be used to enable or disable the NOT-IN predicate-to-anti-join rewrite transformation. It can be specified as a statement-level optimization guideline only. The NOTIN2AJ request element is defined by the complex type notInToAntiJoinType.

XML Schema

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

Description

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