HP Integrity NonStop J-Series User Manual
Page 75
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.
Viewing table statistics and their properties
75