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

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-6
Histogram Tables
Histogram Tables
These tables contain histograms that show how data is distributed with respect to a
column or a group of columns within a table. These statistics enable the optimizer to
create efficient access plans.
SQL/MX HISTOGRAM_INTERVALS and HISTOGRAMS tables are created when a
user schema is created. The UPDATE STATISTICS statement inserts data into these
tables. These files are also called user metadata (UMD) tables.
This table lists SQL/MX user metadata tables (UMD) in each user schema:
If you are using SQL/MP tables for your data, there are histogram tables on the
SQL/MP system. SQL/MP HISTOGRM and HISTINTS tables are automatically created
in the same user catalog as the primary partition of the table you specify when you run
the SQL/MX UPDATE STATISTICS statement. They are kept in SQL/MP files. For
more information about SQL/MP metadata, see the SQL/MP Reference Manual.
This table lists SQL/MP histogram tables:
For detailed descriptions of histogram tables, see User Metadata Tables (UMD):
Histogram Tables on page 10-87.
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA
This schema contains two stored procedures, VALIDATEROUTINE and
VALIDATEROUTINE2, which are for internal use.
NAME2ID Table on page 10-99 Associates service or data source name to ID
RESOURCEPOLICIES Table
on page 10-100
Governing information
HISTOGRAMS Table
on
page 10-89
Columns, interval count, total number of rows and unique
rows, and the low and high values of column distribution
for the table for which the histogram is created
HISTOGRAM_INTERVALS
Table on page 10-91
For each interval of the table for which the histogram is
created, the number of rows and unique rows and the
value of the upper boundary
HISTOGRM Table on
page 10-92
Columns, interval count, total number of rows and unique
rows, and the low and high values of column distribution for
the table for which the histogram is created
HISTINTS Table on
page 10-93
For each interval of the table for which the histogram is
created, the number of rows and unique rows and the value
of the interval upper boundary