Neoview Workload Management Services Guide (R2.4)

Table A-11 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 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
For future useINTEGERCMP_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
130 WMS Commands