HP Integrity NonStop J-Series - Manual (Page 78)

The top pane displays the column name, table name, the percentage sampled, and the time when
the sample was taken.
The following details appear:
•
Data Type: — Displays the column data type.
•
# Nulls: — The number of null values for the column.
•
Skew: — The CV entry from histograms table for this column.
The middle pane displays the ten most frequent values for the column. The value itself and its
cardinality (number of occurrences) appear.
The bottom pane displays the following histogram intervals for the column data boundaries:
•
Interval Number: — The INTERVAL_NUMBER entry from the HISTOGRAM_INTERVALS table.
•
Min Boundary: — The minimum value for the interval, for the column.
•
Max Boundary: — The maximum value for the interval, for the column.
•
Stats UEC: — The total UEC entry from the HISTOGRAMS table for the column.
•
Sampled UEC: — The INTERVAL_UEC from the HISTOGRAM_INTERVALS table.
•
Stats Cardinality: — The STATS_TIME from the HISTOGRAMS table for the column.
•
Sampled Cardinality: — The sampled_UEC from the HISTOGRAMS table for this column.
The diagram at the bottom right relates the Sampled Cardinality to the Interval Number from the
Intervals table located at the left of the diagram.
78 Viewing database objects