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