HP Neoview Release 2.5 Software - Manual (Page 23)

Table 3-1 QUERY_STATS_VW2 Field Definitions (continued)
Description Data Type Field Name
ANSI Timestamp, in Coordinated Universal
Time, indicating when query compilation
began. That is, when a Prepare statement
was issued for this query.
Example: 2009-08-17 15:47:28.791758
TIMESTAMP(6)
DEFAULT NULL COMPILE_START_UTC_TS
ANSI Timestamp, in Local Civil Time,
indicating when query compilation ended.
That is, when the Prepare statement
completed for this query.
Example: 2009-08-17 07:47:28.795259
TIMESTAMP(6)
DEFAULT NULL COMPILE_END_LCT_TS
ANSI Timestamp, in Coordinated Universal
Time, indicating when query compilation
ended. That is, when the Prepare statement
completed for this query.
Example: 2009-08-17 15:47:28.795259
TIMESTAMP(6)
DEFAULT NULL COMPILE_END_UTC_TS
Calculated compile time in microseconds,
computed as compilation end time minus
compilation start time. This is the amount of
time needed to prepare the query.
This value is obtained from the compiler.
Example: 3501
LARGEINT DEFAULT
NULL COMPILE_ELAPSED_TIME
Compile time in seconds, computed as
compilation end time minus compilation
start time. This is the amount of time needed
to prepare the query.
This value is obtained from the compiler.
Example: 0.0035009999999999998
FLOAT(54) DEFAULT
NULL COMPILE_ELAPSED_TIME_SEC
Specifies the choice of CPU Subsets to be
used for placement of ESPs.. The value used
by the compiler for ESP placement for this
query.
Example: 697115338 LARGEINT DEFAULT
NULL COMPILE_AFFINITY_NUM
Degree of parallelism used by the query. The
number of ESP operators that are reused to
parallelize a single fragment of the query
plan. If different fragments in the same plan
are parallelized to different extents, then this
counter reports the degree of parallelization
of the fragment that is parallelized the most.
Example: 0
INTEGER UNSIGNED
DEFAULT NULL COMPILE_DEGREE_OF_PARALLELISM
Indicates whether this query is required to
execute under a transaction. All SQL
statements require a transaction except
SELECT statements that use the READ
UNCOMMITTED isolation level.
Values:
• 1 = True
• 0 = False
INTEGER UNSIGNED
DEFAULT NULL COMPILE_TRANSACTION_NEEDED
Query Statistics 23