HP Neoview Release 2.5 Software - Manual (Page 83)

The Query Details tab provides this information:
• Type: Metrics
Description Field
Query's starting priority. The priority of the NDCS connectivity
server process when this query started execution. Start Priority
Compiler Affinity Number (indicates processors used). Cmp Affinity Num
Degree of parallelism. Compilation Degree of Parallelism
Indicates whether a transaction is needed to run this query. Cmp Txn Needed
Indicates whether there is a cross product. If TRUE, a mandatory
cross product is in the query. This means that the query has a
logical cross product that cannot be avoided by rearranging the
join order. Compilation Mandatory Cross Product
Indicates whether statistics are missing. Cmp Missing Stats
Indicates the number of join operators required. Cmp Num Joins
Indicates (TRUE) whether a full scan of the table is required. This
is indicative of the predicate not using a key-field to restrict the
number of records you need to search. Cmp Full Scan On Table
Contains the cardinality of the largest table that is being fully
scanned. Although multiple tables might be fully scanned for a
given query plan, the counter simply shows the largest of them.
If full table scans are not required, field is empty or shows -1. Cmp Rows Accessed Full Scan
Indicates an estimate of the number of rows accessed in the disk
process. Compilation Disk Process Rows Accessed
Indicates an estimate of the number of rows used in the disk
process. Compilation Disk Process Rows Used
Estimated cost of the query. Estimated Cost
Indicates estimated number of rows returned back from the
query. Cardinality Estimate
Indicates estimated total number of rows that will be accessed
from the disk process by the Executor in the disk process (EID). Rows Access Estimate
Triage Space Query Details 83