SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-34
P
Partitions adding
index A-20
table A-35
Partitions altering file attributes
index A-15
table A-32
Partitions dropping
index A-25
table A-34, A-47
Partitions Format 2
description F-30
EXTENT sizes E-30
MAXEXTENTS M-2
migration A-46
PARTITION clause P-16
PARTNS catalog table
description of P-20
limits L-10, L-11
PARTOF option, LOAD command L-27
PARTONLY option, LOAD command L-27
PARTONLYIN option, LOAD
command L-27
Pascal language
and embedded SQL E-2
record definition, invoking I-26
Pathnames O-6
Pattern matching L-2
Pause while displaying rows S-41
PCV (program catalog version) V-8
Performance
buffered attribute for indexes A-39
catalog considerations for C-132
SQL statement efficiency E-18, E-19,
E-20
Performance considerations
catalogs C-134
DDL C-134
partitions C-134
Peripheral Utility Program (PUP) C-134
PERUSE
command P-21
page size O-9
PFV (program format version) V-8
Physical characteristics of object F-9
Physical primary keys
description of P-27
for indexes I-9
PHYSVOL clause
CREATE INDEX statement C-144
CREATE TABLE statement C-158
PICTURE 9 data syntax D-6
PICTURE X data syntax D-4
PICTURETEXT in COLUMNS table C-47
Plans
altered P-22
description of P-22
inoperable P-22
invalid P-22
operable P-22
optimal P-22
valid P-22
PL/1 S-69
POSITION function P-23
Precision
of expression results E-24
of numeric results E-24
PRECISION in COLUMNS table C-46
Predicates
BETWEEN B-4
comparison C-58
description of P-24
EXISTS E-12
IN I-3
in EXPLAIN report E-16
IS NULL N-6
LIKE L-2
multivalue C-60
NULL N-6
quantified Q-6