beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 121

background image

Table E-7 ODBC_QUERY_STATS_V2 Fields (continued)

Source and Notes

Data Type

Incomplete Queries

Complete Queries

START

TIMESTAMP

QUERY_START_DATETIME

QUERY_START_DATETIME

START

DATE

QUERY_START_DATE

QUERY_START_DATE

START

TIME

QUERY_START_TIME

QUERY_START_TIME

START

TIMESTAMP

QUERY_START_DATETIME_UTC

QUERY_START_DATETIME_UTC

START

DATE

QUERY_START_DATE_UTC

QUERY_START_DATE_UTC

START

TIME

QUERY_START_TIME_UTC

QUERY_START_TIME_UTC

END, or NULL for
an incomplete
query

TIMESTAMP

QUERY_START_DATETIME

QUERY_END_DATETIME

END, or NULL for
an incomplete
query

DATE

QUERY_START_DATE

QUERY_END_DATE

END, or NULL for
an incomplete
query

TIME

QUERY_START_TIME

QUERY_END_TIME

END, or NULL for
an incomplete
query

TIMESTAMP

QUERY_START_DATETIME_UTC

QUERY_END_DATETIME_UTC

END, or NULL for
an incomplete
query

DATE

QUERY_START_DATE_UTC

QUERY_END_DATE_UTC

END, or NULL for
an incomplete
query

TIME

QUERY_START_TIME_UTC

QUERY_END_TIME_UTC

START, else END,
else NULL

DOUBLE
PRECISION

EST_COST

END, or NULL for
an incomplete
query

LARGEINT

QUERY_ELAPSED_TIME

END, or NULL for
an incomplete
query

LARGEINT

MASTER_EXECUTION_TIME

END, or NULL for
an incomplete
query

LARGEINT

DISK_READS

END, or NULL for
an incomplete
query

LARGEINT

LOCK_ESCALATIONS

END, or NULL for
an incomplete
query

LARGEINT

LOCK_WAITS

END, or NULL for
an incomplete
query

LARGEINT

MESSAGE_BYTES_TO_DISK

END, or NULL for
an incomplete
query

LARGEINT

MESSAGES_TO_DISK

Query Statistics for Release 2.4

121