Neoview Workload Management Services Guide (R2.5)

Table A-12 Query Compile-Time Statistics (continued)
DescriptionData TypeColumn Name
Estimated number of seconds it takes for the messaging
for the query. The estimate includes the time for the
number of local and remote messages and the amount of
data sent.
DOUBLE
PRECISION
EST_MSG_TIME
Estimated number of seconds to wait for an event to
happen. Events include opening a table or starting an
executor server process (ESP).
DOUBLE
PRECISION
EST_IDLE_TIME
Estimated number of seconds to execute the query.DOUBLE
PRECISION
EST_TOTAL_TIME
Estimated total number of rows that the query will return.DOUBLE
PRECISION
EST_CARDINALITY
The estimated total memory per CPU used by the query
plan, in kilobytes.
DOUBLE
PRECISION
EST_TOTAL_MEM
The estimated amount of work to be done by the CPUs for
the query, in seconds. (For future use)
INTEGEREST_RESRC_USAGE
The choice of CPU subsets to be used for placement of the
executor server process (ESP).
INTEGERCMP_AFFINITY_NUM
The degree of parallelism used by the query.INTEGERCMP_DOP
Denotes whether the query is required to execute under a
transaction. All SQL statements require a transaction except
SELECT statements that use the READ UNCOMMITTED
isolation level.
INTEGERCMP_TXN_NEEDED
This counter flags queries that have joins without
predicates. Joins without predicates might occur because
of predicate movement during optimization, or they might
occur because the user specified a join without a predicate.
INTEGERCMP_MANDATORY_X_PROD
Denotes if single-column missing statistics warnings were
raised during compilation (with SQLCODE 6008 or 6011).
Multi-column missing statistics warnings (with SQLCODE
6007 or 6010) are not flagged by this counter.
INTEGERCMP_MISSING_STATS
The number of joins in the query plan.INTEGERCMP_NUM_JOINS
Denotes if a full scan will be performed on at least one table
by the query plan.
INTEGERCMP_FULL_SCAN_ON_TABLE
Indicates whether a high disk-processor buffer usage exists:
1 = true
0 = false
NOTE: This counter is for future use.
INTEGERCMP_HIGH_DP2_MAX_BUF_USAGE
The estimated number of rows that will be accessed by a
full scan of a table. If the query plan contains more than
one full scan operation, the full scan that accesses the
maximum number of rows is reported. This counter is valid
only if CMP_FULL_SCAN_ON_TABLE is set.
DOUBLE
PRECISION
CMP_ROWS_ACCESSED_FULL_SCAN
The estimated total number of rows that will be accessed
by all the scan, insert, update, and delete operators in the
query plan.
DOUBLE
PRECISION
CMP_DP2_ROWS_ACCESSED
The estimated total number of rows that will be accessed
by scan and insert operators in the query plan.
DOUBLE
PRECISION
CMP_DP2_ROWS_USED
The process name of the NDCS server (MXOSRVR)VARCHAR(32)PROCESS_NAME
STATUS QUERIES Command 231