Predicate Report

Legend
NameDescription
COLCARDFEstimated number of distinct values in the column.
Column NameColumn name.
Column NumberColumn number.
FFFilter factor.
HIGH2KEYSecond highest value of the column within the partition.
How AppliedHow predicate is being used by the specified operator.
LOW2KEYSecond lowest value of the column within the partition.
Left TableTable on the left-hand-side of the predicate.
Operator IDUnique ID for this operator within this query.
Predicate IDUnique ID for this predicate for the specific operator.
RELOP_TYPE The type of relational operator used in this predicate.
Right TableTable on the right-hand-side of the predicate.
SubqueryWhether or not a data stream from a subquery is required for this predicate. There may be multiple subquery streams required. Possible values are: N (no subquery stream is required), Y (one or more subquery streams is required).
Table NameTable name.
When EvaluatedIndicates when the subquery used in this predicate is evaluated. Possible values are: blank (this predicate does not contain a subquery), EAA (the subquery used in this predicate is evaluated at application (EAA). That is, it is re-evaluated for every row processed by the specified operator, as the predicate is being applied), EAO (the subquery used in this predicate is evaluated at open (EAO). That is, it is re-evaluated only once for the specified operator, and its results are re-used in the application of the predicate for each row), MUL (there is more than one type of subquery in this predicate).




Left Table Right Table 
Table NameColumn NameColumn NumberCOLCARDFHIGH2KEYLOW2KEYRELOP_TYPE Table NameColumn NameColumn NumberCOLCARDFHIGH2KEYLOW2KEYFFOperator IDHow AppliedWhen EvaluatedSubqueryPredicate ID
DB2ADMIN.STORE_SALESSS_SOLD_DATE_SK0-1HSJOINDB2ADMIN.DATE_DIMD_DATE_SK0-10.0400002JOIN N5
DB2ADMIN.DATE_DIMD_DATE_SK0-1HSJOINDB2ADMIN.STORE_SALESSS_SOLD_DATE_SK0-10.0400002JOIN N5
 D_MOY8-1TBSCAN    0.3333334SARG N2
      TBSCAN    0.3333334SARG N3
 D_YEAR6-1TBSCAN    0.0400004SARG N4