Neoview Workload Management Services Guide (R2.5)

Compile-Time Metrics
This table describes the compile-time metrics for the query:
DescriptionName
Estimated cost of the queryEstimated Cost
Estimated number of rows returned by the queryCardinality Estimate
Estimated total amount of processor (CPU) timeCpu Time Estimate
Estimated total amount of I/O timeIo Time Estimate
Estimated total amount of messaging timeMsg Time Estimate
Estimated idle timeIdle Time Estimate
Estimated total timeEstimated Total Time
Estimated total number of rows that will be accessed by all the scan,
insert, update, and delete operators in the query plan
Rows Access Estimate
Estimated total number of rows that will be accessed by scan and insert
operators in the query plan
Rows Usage Estimate
Estimated total amount of memoryTotal Memory Estimate
Estimated total resource usageResource Usage Estimate
Compiler affinity number, indicating the number of processors usedCmp Affinity Num
Degree of parallelismCompilation Degree Of Parallellism
Indicates whether a transaction is needed:
1 = true
0 = false
Cmp Txn Needed
Indicates whether a cross product exists:
1 = true
0 = false
Compilation Mandatory Cross Product
Indicates whether statistics are missing:
1 = true
0 = false
Cmp Missing Stats
Number of join operators that are requiredCmp Num Joins
Indicates whether a full scan of the table is required:
1 = true
0 = false
A condition of true indicates that the predicate was not using a key-field
to restrict the number of records to search.
Cmp Full Scan On Table
Indicates whether a high disk-processor buffer usage exists:
1 = true
0 = false
NOTE: This counter is for future use.
Compilation High Esam Max Buffer Usage
Estimated number of rows accessed for a full scanCmp Rows Accessed Full Scan
Estimated number of rows accessed in the disk processCompilation Disk Process Rows Accessed
Estimated number of rows used in the disk processCompilation Disk Process Rows Used
Monitor Queries 135