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

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

XML Schema

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


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