SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-7
VALIDATEROUTINE: Schema
SYSTEM_SQLJ_SCHEMA
This table lists SQL/MP histogram tables:
For detailed descriptions of histogram tables, see User Metadata Tables (UMD):
Histogram Tables on page 10-81.
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA
This schema contains only the stored procedure VALIDATEROUTINE, which is for
internal use.
HISTOGRM Table on
page 10-86
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-87
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