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
SARAVIND.EMPLOYEEEMPNO042'200330''000020'NLJOINSARAVIND.DEPARTMENTMGRNO29'000100''000020'0.0238104JOIN N7
      NLJOINSARAVIND.PROJECTRESPEMP317'000330''000020'0.0238105JOIN N3
      FETCHSARAVIND.PROJECTRESPEMP317'000330''000020'0.0238109SARG N3
      FETCH    1.0000009SARG N4
      IXSCANSARAVIND.PROJECTRESPEMP317'000330''000020'0.02381013STARTSTOP N3
      IXSCAN    1.00000013STOPSARG N4
      IXSCANSARAVIND.DEPARTMENTMGRNO29'000100''000020'0.02381015STARTSTOP N7
 WORKDEPT48'E11''B01'NLJOINSARAVIND.DEPARTMENTDEPTNO014'I22''B01'0.0714295JOIN N2
      NLJOINSARAVIND.PROJECTDEPTNO28'E11''C01'0.1250005JOIN N11
      FETCHSARAVIND.DEPARTMENTDEPTNO014'I22''B01'0.0714299SARG N2
      IXSCANSARAVIND.DEPARTMENTDEPTNO014'I22''B01'0.07142914STARTSTOP N2
      IXSCANSARAVIND.PROJECTDEPTNO28'E11''C01'0.12500014STARTSTOP N11
SARAVIND.DEPARTMENTMGRNO29'000100''000020'NLJOINSARAVIND.EMPLOYEEEMPNO042'200330''000020'0.0238104JOIN N7
      NLJOINSARAVIND.PROJECTRESPEMP317'000330''000020'0.0588244JOIN N9
      IXSCAN    0.57142915STOPSARG N6
      IXSCANSARAVIND.EMPLOYEEEMPNO042'200330''000020'0.02381015STARTSTOP N7
      IXSCANSARAVIND.PROJECTRESPEMP317'000330''000020'0.05882415STARTSTOP N9
 DEPTNO014'I22''B01'NLJOINSARAVIND.EMPLOYEEWORKDEPT48'E11''B01'0.0714295JOIN N2
      NLJOINSARAVIND.PROJECTDEPTNO28'E11''C01'0.0714296JOIN N10
      IXSCANSARAVIND.PROJECTDEPTNO28'E11''C01'0.0714298STARTSTOP N10
      FETCHSARAVIND.EMPLOYEEWORKDEPT48'E11''B01'0.0714299SARG N2
      IXSCANSARAVIND.EMPLOYEEWORKDEPT48'E11''B01'0.07142914STARTSTOP N2
 LOCATION41''''IXSCAN    0.0400007STARTSTOP N8
SARAVIND.PROJECTRESPEMP317'000330''000020'NLJOINSARAVIND.DEPARTMENTMGRNO29'000100''000020'0.0588244JOIN N9
      NLJOINSARAVIND.EMPLOYEEEMPNO042'200330''000020'0.0238105JOIN N3
      IXSCAN    1.0000008STOP N5
      FETCHSARAVIND.EMPLOYEEEMPNO042'200330''000020'0.0238109SARG N3
      IXSCANSARAVIND.EMPLOYEEEMPNO042'200330''000020'0.02381013STARTSTOP N3
      IXSCANSARAVIND.DEPARTMENTMGRNO29'000100''000020'0.05882415STARTSTOP N9
 DEPTNO28'E11''C01'NLJOINSARAVIND.EMPLOYEEWORKDEPT48'E11''B01'0.1250005JOIN N11
      NLJOINSARAVIND.DEPARTMENTDEPTNO014'I22''B01'0.0714296JOIN N10
      IXSCANSARAVIND.DEPARTMENTDEPTNO014'I22''B01'0.0714298STARTSTOP N10
      IXSCANSARAVIND.EMPLOYEEWORKDEPT48'E11''B01'0.12500014STARTSTOP N11