SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-23
P
P
PARALLEL_NUM_ESPS default 10-58
Parameter specification
examples of 6-75
names 6-74
type assignments 6-73
Parameters in dynamic SQL, restrictions on
use 2-160
PARTITION clause
examples 7-7
syntax diagram of 7-5
Partition Overlay Specification (POS)
default attributes 10-51
description of 2-89
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-55
CREATE TABLE, FIRST KEY
specification 2-84
Partitions
automatic creation 2-89
description of 6-79
hash 6-79
hash, MODIFY utility 5-53
limits C-1
managing 5-47
range 6-79
range, MODIFY utility 5-47, 5-49
PARTITIONS metadata table 10-20
Path name, CD command use of 4-7
Performance
buffer size 10-55, 10-56
character string data types 6-21
CLEARONPURGE file attribute 8-5
compound statements 3-14
constraint droppable options 10-40
constraints 2-21
CONTROL TABLE statement 2-46
CREATE TABLE and
DROPPABLE 2-78
Performance (continued)
DECLARE CURSOR statement 3-25
extent sizes 8-6
hash join 2-38
import utility 5-35
MODIFY utility 5-60
online transaction optimization 4-17,
10-57
ORDER BY clause 2-195
query execution, histograms 10-41
query optimization 10-54
row maintenance 10-61
SAMPLE statement, cluster
sampling 7-11
STORE BY clause 7-23
Physical name 6-12
PI function
examples of 9-104
syntax diagram of 9-104
PICTURE data type, character string 6-20
PICTURE data type, numeric 6-33
PM_OFFLINE_TRANSACTION_GRANULA
RITY default 10-52
PM_ONLINE_TRANSACTION_GRANULA
RITY default 10-52
POPULATE INDEX utility
examples of 5-75
syntax description 5-73
Populating indexes 2-57
POS
See Partition Overlay Specification
POSITION function
examples of 9-106
result of 9-105
syntax diagram of 9-105
POS_LOCATIONS default 10-53
POS_NUM_OF_PARTNS default 10-53
POS_RAISE_ERROR default 10-53
POWER function
examples of 9-106
syntax diagram of 9-106