HP Neoview Release 2.4 Software User Manual
Page 28
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