XML schema for the STMTMATCH element

The STMTMATCH element enables the matching method used for the optimization profile or for specific statements in the optimization profile.

It is defined by the complex type stmtMatchType.
XML Schema

   <xs:complexType name="stmtMatchType">
      <xs:attribute name="EXACT" type="boolType" use="optional" default="TRUE"/>


The optional EXACT attribute specifies the matching method. If the value is set to TRUE, exact matching is applied. If the value is set to FALSE, inexact matching is applied. Exact matching is the default setting.


The following example shows an STMTMATCH element definition at the statement level which enables inexact matching for the statement in the STMTKEY element.
          <![CDATA[select t1.c1, count(*) from t1,t2 where t1.c1 = t2.c1 and t1.c1 > 0]]>