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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-11
Definition Schema Tables
Definition Schema Tables
ACCESS_PATHS Table
ACCESS_PATHS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that describes physical instances of data in the catalog. (A physical instance of data is
a simple table, an index, or a partition of a table or index.)
Column Name Data Type Description
1 TABLE_UID LARGEINT UID of base table for path; link to
OBJECTS
*2 ACCESS_PATH_UID LARGEINT If path is index, UID of index;
otherwise, UID of base table
3 ACCESS_PATH_TYPE CHAR(2) BT Base Table
IX Index
4 COLUMN_COUNT INT Number of rows in table
ACCESS_PATH_COLUMNS directly
associated with this access path
5 UNIQUE_COLUMN_COUNT INT Number of rows in table
ACCESS_PATH_COLUMNS in
unique key for this access path
6 VALID_DATA CHAR(2) Y if valid data
N if not
7 RECORD_SIZE INT Number of bytes in each logical
record
8 UNIQUES CHAR(2) Y if each row in this access path is
unique
N if not
9 EXPLICIT CHAR(2) Y if user-created index
N if not
10 CLUSTERING_SCHEME CHAR(2) Physical organization of this access
path:
KS if by key
11 PARTITIONING_SCHEME CHAR(2) Partitioning method for this access
path:
RP if by first key
SP if by size
N if not partitioned
HP if hash partitioned
12 BLOCK_SIZE INT Number of bytes for disk blocks on
this access path
13 KEY_LENGTH INT Number of bytes in key
14 PARTITIONING_KEY_LENGTH INT Number of bytes in partitioning key
* Indicates primary key