Legend | Name | Description |
---|
COLCARDF | Estimated number of distinct values in the column. |
---|
Column Name | Column name. |
---|
Column Number | Column number. |
---|
FF | Filter factor. |
---|
HIGH2KEY | Second highest value of the column within the partition. |
---|
How Applied | How predicate is being used by the specified operator. |
---|
LOW2KEY | Second lowest value of the column within the partition. |
---|
Left Table | Table on the left-hand-side of the predicate. |
---|
Operator ID | Unique ID for this operator within this query. |
---|
Predicate ID | Unique ID for this predicate for the specific operator. |
---|
RELOP_TYPE | The type of relational operator used in this predicate. |
---|
Right Table | Table on the right-hand-side of the predicate. |
---|
Subquery | Whether 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 Name | Table name. |
---|
When Evaluated | Indicates 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). |
---|