beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 28

background image

Table 3-3 ODBC_QUERY_STATS_V2 Fields (continued)

Source and Notes

Data Type

Incomplete Queries

Complete Queries

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_EXEC_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)
or NCHAR
VARYING(3200)

SQL_TEXT

28

Repository Views