SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-24
P
Parameters in dynamic SQL, restrictions on
use 2-237
PARTITION clause
examples 7-8
syntax diagram of 7-6
Partition Overlay Specification (POS)
default attributes 10-65
description of 2-115
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-75
CREATE TABLE, FIRST KEY
specification 2-109
Partitions
automatic creation 2-115
description of 6-83
hash 6-83
hash, MODIFY utility 5-87
limits C-1
managing 5-79
range 6-83
range, MODIFY utility 5-79, 5-81
PARTITIONS metadata table 10-25
Path name, CD command use of 4-8
Performance
buffer size 10-70, 10-71
character string data types 6-24
CLEARONPURGE file attribute 8-5
compound statements 3-14
constraint droppable options 10-52
constraints 2-26
CONTROL TABLE statement 2-66
CREATE TABLE and
DROPPABLE 2-101
DECLARE CURSOR statement 3-25
extent sizes 8-6
hash join 2-58
import utility 5-62
MODIFY utility 5-98
online transaction optimization 10-73
ORDER BY clause 2-276
query execution, histograms 10-53
query optimization 10-68
row maintenance 10-77
SAMPLE statement, cluster
sampling 7-12
STORE BY clause 7-24
Physical name 6-13
PI function
examples of 9-130
syntax diagram of 9-130
PICTURE data type, character string 6-23
PICTURE data type, numeric 6-36
PM_OFFLINE_TRANSACTION_GRANULA
RITY default 10-66
PM_ONLINE_TRANSACTION_GRANULA
RITY default 10-66
POPULATE INDEX utility
examples of 5-129
syntax description 5-127
Populating indexes 2-77
POS
See Partition Overlay Specification
POSITION function
examples of 9-132
result of 9-131
syntax diagram of 9-131
POS_LOCATIONS default 10-66
POS_NUM_OF_PARTNS default 10-66
POS_RAISE_ERROR default 10-67
POWER function
examples of 9-132
syntax diagram of 9-132
Precision, description of 6-53
Predicates
summary of 6-85
BETWEEN 6-86
comparison 6-88
description of 6-85
EXISTS 6-92
IN 6-94