HP Neoview Release 2.5 Software - Manual (Page 48)

Description Metric
Indicates the difference (current – previous interval samples) in
the number of rows inserted, updated, or deleted. Delta IUD
Provides the rate of the number of rows inserted, updated, or deleted
per second. IUD/Second
Compile-Time Metrics
Compile-time metrics are used by Neoview SQL to generate query plans and provides a view
of the estimates of resources required by a query. This information is static for the life of a query
(meaning it does not change while a query executes). Depending on the version of the platform
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. 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
Indicates high disk processor buffer usage. Compilation_High_ESAM_Max_Buffer_Usage
Contains the cardinality of the largest table that is being scanned fully.
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
48 Neoview Workload Management Services (WMS) Configuration