DB2 10.5 for Linux, UNIX, and Windows

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"/>
   </xs:complexType>

Description

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.

Example

The following example shows an STMTMATCH element definition at the statement level which enables inexact matching for the statement in the STMTKEY element.

<STMTPROFILE ID='S1'>
      <STMTMATCH  EXACT='FALSE'/>
      <STMTKEY>           
          <![CDATA[select t1.c1, count(*) from t1,t2 where t1.c1 = t2.c1 and t1.c1 > 0]]>
      </STMTKEY>
      ...
</STMTPROFILE>