If you have applications that use views from previous releases, the queries will continue to work
and access current query statistics. However, queries against views from previous releases cannot
use the new and revised columns. Also, some fields may no longer be available in
QUERY_STATS_VW2. If a field is no longer available, NULL is returned when you run queries
using the view. It is recommended that you adjust your applications as soon as possible to use
the QUERY_STATS_VW2 view. For query statistics information prior to R2.5, see

“Pre-R2.5

Query Statistics Views” (page 89)

VIEW NEO.HP_METRICS.QUERY_STATS_VW2

The Repository collects compilation and execution query statistics.

This view provides access to all query information. The SQL text for the query is also included,
up to 254 characters. If the SQL text is longer than 254 characters, the
SQL_TEXT_OVERFLOW_INDICATOR

field is set to 1 to indicate that only part of the SQL text fits

in this view, and the complete SQL text is placed in the SQL_TEXT_VW1 view. In this case,
QUERY_STATS_VW2 has the first 254 characters and SQL_TEXT_VW1 has the complete SQL
text. The QUERY_STATS_VW2 view can be joined with the SQL_TEXT_VW1 view through the
EXEC_START_LCT_TS (or EXEC_START_UTC_TS) and QUERY_ID fields to fetch the full SQL
text for the query.

Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.

The Primary Key for QUERY_STATS_VW2 field definition is EXEC_START_UTC_TS and
QUERY_ID.

Overview