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.REPAIRR_ORDER_NUMBER20  NLJOINDB2ADMIN.CATALOG_RETURNSCR_ORDER_NUMBER160  1.0000005JOIN N4
      FETCH    0.3333336SARG N8
      IXSCANDB2ADMIN.CATALOG_RETURNSCR_ORDER_NUMBER160  1.0000009STARTSTOP N4
 R_ITEM_SK10  NLJOINDB2ADMIN.CATALOG_RETURNSCR_ITEM_SK20  1.0000005JOIN N5
      IXSCANDB2ADMIN.CATALOG_RETURNSCR_ITEM_SK20  1.0000009STARTSTOP N5
DB2ADMIN.CATALOG_RETURNSCR_ORDER_NUMBER160  NLJOINDB2ADMIN.REPAIRR_ORDER_NUMBER20  1.0000005JOIN N4
      IXSCAN    0.3333339STARTSARG N3
      IXSCANDB2ADMIN.REPAIRR_ORDER_NUMBER20  1.0000009STARTSTOP N4
 CR_ITEM_SK20  NLJOINDB2ADMIN.REPAIRR_ITEM_SK10  1.0000005JOIN N5
      IXSCANDB2ADMIN.REPAIRR_ITEM_SK10  1.0000009STARTSTOP N5
 CR_RETURN_SHIP_COST220  FETCH    0.3333338SARG N7