SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables

HP NonStop SQL/MX Reference Manual—540440-003

10-73

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.

* Indicates primary key