HP Neoview Release 2.5 Software - Manual (Page 204)

Description Field Group Box
Estimated total amount of processor (CPU) time CPU
Estimated total amount of I/O time I/O
Estimated total amount of messaging time Message
Estimated idle time Idle
Estimated total time Total Time
Estimated number of rows returned by the query Cardinality
Estimated total amount of memory Total Memory
Estimated total resource usage Res. Usage
Compiler affinity number, indicating the number of processors used Affinity Number Other
Degree of parallelism Degree of Parallelism
Indicates whether a transaction is needed:
1 = true
0 = false
Transaction Needed
Indicates whether a cross product exists:
1 = true
0 = false
Mandatory X Prod
Indicates whether statistics are missing:
1 = true
0 = false
Missing Stats
Number of join operators that are required Number 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.
Full Scan on Table
Estimated number of rows accessed for a full scan Rows Full Scan
Maximum buffer usage by the disk processor EID Max Buffer Usage
Estimated number of rows accessed in the disk process EID Rows Accessed
Estimated number of rows used in the disk process EID Rows Used
Displayed as rule-name:expr-num, where rule-name is the last
connection rule evaluated for the query and expr-num is the total
number of rule expressions Conn Rule
Displayed as rule-name:expr-num, where rule-name is the last
compilation rule evaluated for the query and expr-num is either the
ordinal position of the expression that evaluated to true or ALL for all
expressions evaluating to true Comp Rule
Displayed as rule-name:expr-num, where rule-name is the last
execution rule evaluated for the query and expr-num is either the
ordinal position of the expression that evaluated to true or ALL for all
expressions evaluating to true. Exec Rule
204 Find Offending Processes and Queries