The following properties are shown in the Full detail mode of the Operator
Details window:
- Tables
- The set of tables that has been accessed thus far in the access
plan.
- Columns
- The set of columns that has been accessed thus far in the access
plan.
- Order Columns
- The columns on which this stream is ordered. They can be ascending
(ASC), or descending (DESC). A value of -1 indicates that they are not
ordered.
- Predicates
- The set of predicates applied (including an
estimate of their selectivity).
- Cardinality
- The estimated number of rows to be returned.
Be sure to use the runstats command after making your
table updates; otherwise, the table may appear to be empty to the
optimizer. This problem is evident if the number of rows is zero
(0). In this case, complete your table updates, rerun runstats, and recreate the explain snapshots
for the table.
- Total Buffer Pool Pages Used
- The estimated number of pages in the buffer pool that will be required
during processing of this operator and its inputs.
-
Partitioning map identifier
- A partition number that maps a partitioning
map index to database partitions in the nodegroup.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]