beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 85

background image

Table C-3 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)

Description

Data Type

Field Name

Cumulative list of columns for which
statistics are missing, or “-” if the data is not
the result of a runtime warning. Value is a
comma-separated list in which each member
has the form column(number) or (column,
column

)(number), where column is a

column name, and number is the
corresponding number of missing statistics
warnings. If no columns with missing
statistics have been identified so far, the
value in this field is NULL.

VARCHAR(1740)

MISSING_STATS

Proposed repair action (update statistics), or
“-” if the data is not the result of a runtime
warning. If no columns with missing
statistics have been identified so far, the
value in this field is NULL.

VARCHAR(1024)

REPAIR_ACTION

Table Statistics

85