HP Neoview Release 2.4 Software - Manual (Page 41)

to which you are connected, the information displayed will vary. This document provides a short
description for the metrics:
Description Metric
Indicates estimated cost of the query. Estimated Cost
Indicates estimated number of rows returned back from the query. Cardinality Estimate
Indicates estimated total amount of processor (CPU) time. CPU Time Estimate
Indicates estimated total amount of IO time. IO Time Estimate
Indicates estimated total amount of messaging time. Msg Time Estimate
Indicates estimated idle time. Idle Time Estimate
Total time estimate. Estimated Total Time
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
Indicates estimated total number of rows that will be used. This is the
compiler estimate of the number of rows that the Executor returns in
the disk process (EID) after applying the predicates. Rows Usage Estimate
Indicates estimated total amount of memory. Total Memory Estimate
Indicates estimated total resource usage. Resource Usage Estimate
Compiler Affinity Number (indicates processors used). CMP Affinity Num
Degree of parallelism. Compilation Degree Of Parallellism
Indicates whether a transaction is needed to run this query. CMP TXN Needed
Indicates whether there is a cross product. Compilation Mandatory Cross Product
Indicates whether statistics are missing. CMP Missing Stats
Indicates the number of join operators required. CMP Num Joins
Indicates 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
Indicates high disk processor buffer usage. Compilation_High_ESAM_Max_Buffer_Usage
Indicates the estimated number rows accessed for a full scan. 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
Run-Time Metrics
Run-time metrics indicate the actual resources that have been currently used by the query or
metrics that relate to the current state of the query. This information varies and will change over
time when this information is sampled or aggregated. Depending on the version of the platform
to which you are connected, the information displayed will vary. This document provides a short
description of the metrics:
Description Metric
Indicates the query’s execution state. Exec State
Error code value. Error Code
Configuring Neoview WMS Services and Rules With Live View 41