NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-34
P
unnamed P-13
using P-13
PART option, CONVERT command C-93
Partial query results C-82
PARTITION ARRAY attribute,
displaying F-20
PARTITION ARRAY clause
ALTER TABLE statement A-31
CREATE TABLE statement C-148
PARTITION clause
CREATE INDEX statement C-137
CREATE TABLE statement C-148
description of P-16
PARTITIONARRAY, in FILES table F-29
PARTITIONED, in FILES table F-28
Partitioning tables L-10
PARTITIONNAME, in PARTNS table P-20
Partitions
adding
index A-20
table A-32
allocating disk space for A-7
altering file attributes
index A-15
table A-30
attributes C-102
catalog description of P-20
changing array size A-31
defaults for first key columns P-17
defining P-16
description of P-19
dropping
index A-24
table A-31, A-42
in catalog D-52
in EXPLAIN report E-17, E-18
loading in parallel C-136
lock for L-45, L-46, L-47
memory errors L-9
modifying partition array A-42
names G-7
number limit L-9
performance considerations C-128
primary P-19
reusing A-34, A-43
secondary P-19
size limit L-8
skip/stop at unavailable C-78
statistics for U-10
table
adding A-38
PARTNS catalog table
description of P-20
limits L-9
PARTOF option, LOAD command L-26
PARTONLY option, LOAD command L-26
Pascal language
and embedded SQL E-1
record definition, invoking I-26
Pathnames O-6
Pattern matching L-2
Pause while displaying rows S-41
PCV (program catalog version) V-7
Performance
buffered attribute for indexes A-36
catalog considerations for C-127
SQL statement efficiency E-18, E-20,
E-21
Performance considerations
catalogs C-128
DDL C-128
partitions C-128
Peripheral Utility Program (PUP) C-128,
C-129
PERUSE command P-20
PERUSE page size O-9
PFS (Process File Segment)
and DEFINEs D-26