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

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-12
ACCESS_PATHS Table
In version 1200 schemas, the primary key consists of the ACCESS_PATH_UID
column. In version 3000 schemas, the primary key consists of the columns in the
following order:
1. TABLE_UID
2. ACCESS_PATH_UID
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
27 INSERT_MODE CHAR(2) Reserved for future use
28 MAX_TABLE_SIZE INT Reserved for future use
29 RESERVED_FILLER_INT INT Reserved for future use
30 RESERVED_FILLER_CHAR CHAR(20) Reserved for future use
31 DISK_POOL INT Reserved for future use
32 NUM_DISK_POOL INT Reserved for future use
* Indicates primary key
Column Name Data Type Description