SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-33
P
PAGE TITLE command (continued)
IF/THEN/ELSE clause I-1
PAGE_COUNT layout option P-1, R-10
PAGE_LENGTH layout option P-2, R-10
PAGE_NUMBER function P-3, R-11
PAID (Process Access ID) S-13
Parallel execution
in EXPLAIN report E-18
loading indexes C-145
query C-73, C-74
similarity, effect on S-54
PARALLEL EXECUTION clause, CREATE
INDEX statement C-145
PARALLEL EXECUTION option, LOAD
command L-32
Parallel index loading
description of P-5
partitions C-145
Parallel writes
compared to serial S-32
description of S-32
PARAM attribute, SAVE command S-2
Parameters
description of P-11
displaying current value S-50
dynamic SQL and default data
types P-13
indicator I-11
name P-13
prepared commands P-25
resetting R-14
saving in a file S-2
setting value for S-35
specifying type of C-4, P-14
unnamed P-13
using P-13
PART option, CONVERT command C-97
Partial query results C-87
PARTITION ARRAY attribute,
displaying F-20
PARTITION ARRAY clause
ALTER TABLE statement A-33
CREATE TABLE statement C-159
PARTITION clause
CREATE INDEX statement C-145
CREATE TABLE statement C-158
description of P-16
Partition format A-46
PARTITIONARRAY, in FILES table F-28
PARTITIONED, in FILES table F-27
PARTITIONNAME, in PARTNS table P-20
Partitions
allocating disk space for A-7
attributes C-108
catalog description of P-20
changing array size A-33
defaults for first key columns P-17
defining P-16
description of P-19
format P-19
FORMAT file attribute F-30
in catalog D-55
in EXPLAIN report E-16, E-17
loading in parallel C-145
lock for L-48, L-49, L-50
memory errors L-10, L-11
modifying partition array A-47
moving, index A-25
names G-7
number limit L-9
performance considerations C-134
primary P-19
reusing A-37, A-47
secondary P-19
size limit L-9
skip/stop at unavailable C-83
statistics for U-10
table, adding A-40