SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-89
HISTOGRAM_INTERVALS Table
HISTOGRAM_INTERVALS Table
The SQL/MX HISTOGRAM_INTERVALS table describes for each interval, the number
of rows and number of unique rows in the interval and the value of the upper boundary
for the interval:
Column Name Data Type Description
*1 TABLE_UID LARGEINT The UID of the table for which this
histogram is generated.
*2 HISTOGRAM_ID INT UNSIGNED System-generated ID for the histogram.
Each HISTOGRAM_ID has a
corresponding ID in the HISTOGRAMS
table.
*3 INTERVAL_NUMBER SMALLINT Sequence number for this interval.
4 INTERVAL_ROWCOUNT LARGEINT Number of rows in this interval.
5 INTERVAL_UEC LARGEINT Number of unique entries in this interval.
6 INTERVAL_BOUNDARY VARCHAR(250)
CHARACTER
SET UCS2\
The value of the upper boundary for this
interval.
7 STD_DEV_OF_FREQ NUMERIC(12,3) The standard deviation of F, where F is the
set of {f1, … fn}, fi is the # of occurrences of
value i in the interval, and n is the UEC of
the interval
8 V1 LARGEINT Reserved for future use
9 V2 LARGEINT Reserved for future use
10 V3 LARGEINT Reserved for future use
11 V4 LARGEINT Reserved for future use
12 V5 VARCHAR(250)
UCS2
COLLATE
Reserved for future use
13 V6 VARCHAR(250)
UCS2
COLLATE
Reserved for future use
* Indicates primary key