HP Neoview Release 2.5 Software - Manual (Page 127)

Table E-8 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
Estimated number of rows to be
accessed from Disk Process at runtime
by EID (Executor in Disk Process). This
value is meaningful for SELECT, not
for Insert/Update/Delete. For
Insert/Update/Delete, the value is
reported as 0.0. DOUBLE PRECISION NO DEFAULT EST_ACCESSED_ROWS*
Estimated number of rows to be
returned by EID after applying
selection predicates DOUBLE PRECISION NO DEFAULT EST_USED_ROWS*
Estimated cost (time in seconds) of the
SQL operations in the Master Executor.
The estimate occurs at the time the
query is prepared. DOUBLE PRECISION NO DEFAULT EST_COST*
Estimate of the number of seconds of
I/O time (seeks plus data transfer) to
perform the I/O for this query. The
estimate occurs at the time the query
is prepared. DOUBLE PRECISION NO DEFAULT EST_IO_TIME*
Estimate of the number of seconds
required for the messaging for this
query, including local and remote
messages, and the amount of data sent.
The estimate occurs at the time the
query is prepared. DOUBLE PRECISION NO DEFAULT EST_MESSAGE_TIME*
Estimate of the number of seconds to
wait for an operation to complete, (e.g.,
opening a table or starting a process).
The estimate occurs at the time the
query is prepared. DOUBLE PRECISION NO DEFAULT EST_IDLE_TIME*
Estimate of the number of seconds of
processor time it might take to execute
the query. The estimate occurs at the
time the query is prepared. DOUBLE PRECISION NO DEFAULT EST_NODE_TIME*
Estimated total cost of the query, in
seconds. The cost for this operator plus
all operators below this operator in the
tree. For the Master, this is all other
operators in the tree. Sum of
EST_IDLE_TIME, EST_IO_TIME,
EST_MSG_TIME, and
EST_NODE_TIME. The estimate
occurs at the time the query is
prepared. DOUBLE PRECISION NO DEFAULT EST_TOTAL_TIME*
Estimated number of rows that will be
returned. The estimate occurs at the
time the query is prepared. DOUBLE PRECISION NO DEFAULT EST_CARDINALITY*
Number of bytes returned for statistics
counts. LARGEINT SIGNED NO DEFAULT STATS_BYTES*
Query Statistics for Release 2.4 127