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

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-13
ACCESS_PATHS Table
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:
N Not partitioned
RP Range partitioned by first key
HP Hash-1 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
15 LOCK_LENGTH INT Reserved for future use
16 AUDITED CHAR(2) Y if this path is audited
N if not
17 AUDIT_COMPRESS CHAR(2) Y if audit is compressed
N if not
18 CLEAR_ON_PURGE CHAR(2) Y if deleted records are cleared
N if not
19 BUFFERED CHAR(2) Reserved for future use
20 RECORD_PACKED CHAR(2) Reserved for future use
21 DATA_COMPRESSED CHAR(2) Reserved for future use
22 INDEX_COMPRESSED CHAR(2) Y if index blocks are compressed
N if not
23 PACKING_SCHEME INT Reserved for future use
24 PACKING_FACTOR INT Reserved for future use
25 ALL_COLUMNS_INCLUDED CHAR(2) Y if all columns included
N if not
26 ROW_FORMAT CHAR(2) Reserved for future use
Column Name Data Type Description