beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 91

background image

Table C-3 ODBC_QUERY_STATS_V2_2400 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

END, or NULL for
an incomplete query

LARGEINT

ROWS_ACCESSED

END, or NULL for
an incomplete query

LARGEINT

ROWS_RETRIEVED

END, or NULL for
an incomplete query

LARGEINT

NUM_ROWS_IUD

END, or NULL for
an incomplete query

LARGEINT

TOTAL_EXECUTES

START

VARCHAR(3200)

SQL_TEXT

VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400

91