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

Metadata Tables

HP NonStop SQL/MX Reference Manual—540440-003

10-75

HISTINTS Table

The SQL/MP table HISTINTS table is a user table registered in the catalog of the

primary partition of the table specified in the UPDATE STATISTICS statement that

created the histogram tables. It describes, for each interval of the table for which the

histogram is created, the number of rows and unique rows in the interval and the value

of the interval upper boundary.

Caution. HISTINTS is an SQL/MP user table with the security of the user who runs the

UPDATE STATISTICS command on the user tables of a particular SQL/MP catalog. It does not

have the same protection as the SQL/MP catalog tables, which can be modified by licensed

processes only. As such, system users who have write access to the table could enter invalid

data, which could affect the performance or operation of NonStop SQL/MX. Therefore, you

should secure access to the HISTINTS table to a restricted group of users.

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 HISTOGRM

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(500) The value of the upper boundary for this

interval.

* Indicates primary key