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

7. In the right pane, click Statistics.
The following histogram statistics for the table appear:
•
Column Name: — The name of the column.
•
Data Type: — This attribute specifies the column data type.
•
# Nulls: — The number of null values for the column.
•
Min Value: — The minimum value of the column.
•
Max Value: — The maximum value of the column.
•
Skew: — The CV entry in histograms table for the column.
•
UEC: — The TOTAL_ UEC (Unique Entry Count) entry from histograms table for the
column.
•
Cardinality: — The ROWCOUNT entry from histograms table for the column.
•
Last Stats Timestamp: — The STATS_TIME from histogram table for the column.
NOTE: The Statistics tab includes information only if the table statistics are stored. To store
the table statistics, you must execute the Update Statistics statement on the table.
Figure 27 (page 77) shows the table statistics.
Figure 27 Table statistics
For more information on the HISTOGRAMS table, see the HP NonStop SQL/MX Release 3.2.1
Reference Manual.
To display a sample view of the table column statistics, click the column name, double-click any
row in the right pane, or click View Sampled Column Statistics located at the top right pane.
Viewing table statistics and their properties 77