SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-8
SQL/MX Metadata Tables
HISTOGRAM_INTERVALS TABLE_UID
HISTOGRAM_ID
INTERVAL_NUMBER
INTERVAL_ROWCOUNT
INTERVAL_UEC
INTERVAL_BOUNDARY
MVS_TABLE_INFO_UMD Reserved for future use
MVS_UMD Reserved for future use
MVS_USED_UMD Reserved for future use
DEFINITION_SCHE
MA_VERSION_1200
ACCESS_PATHS ACCESS_PATH_UID
TABLE_UID
ACCESS_PATH_TYPE
COLUMN_COUNT
UNIQUE_COLUMN_COUNT
VALID_DATA
RECORD_SIZE
UNIQUES
EXPLICIT
CLUSTERING_SCHEME
PARTITIONING_SCHEME
BLOCK_SIZE
KEY_LENGTH
PARTITIONING_KEY_LENGTH
LOCK_LENGTH
AUDITED
AUDIT_COMPRESS
CLEAR_ON_PURGE
BUFFERED
RECORD_PACKED
DATA_COMPRESSED
INDEX_COMPRESSED
PACKING_SCHEME
PACKING_FACTOR
ALL_COLUMNS_INCLUDED
ACCESS_PATH_COLS ACCESS_PATH_UID
POSITION_IN_ROW
COLUMN_NUMBER
ORDERING
PART_KEY_SEQ_NUM
CLUSTERING_KEY_SEQ_NUM
SYSTEM_ADDED_COLUMN
CK_COL_USAGE CONSTRAINT_UID
TABLE_UID
COLUMNN_NUMBER
SELECTS
Table 8-1. SQL/MX Metadata Tables (page 3 of 8)
Schema Table Columns (Clustering Keys in Bold)