SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-24
P
description of 2-127
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-83
CREATE TABLE, FIRST KEY
specification 2-121
Partitions
automatic creation 2-127
description of 6-83
hash 6-83
hash, MODIFY utility 2-281
limits C-1
managing 2-271
range 6-83
range, MODIFY utility 2-271, 2-274
PARTITIONS metadata table 10-24
Path name, CD command use of 4-8
Performance
buffer size 10-68, 10-69
character string data types 6-24
CLEARONPURGE file attribute 9-5
compound statements 3-14
constraint droppable options 10-51
constraints 2-33
CONTROL TABLE statement 2-74
CREATE TABLE and
DROPPABLE 2-113
DECLARE CURSOR statement 3-25
extent sizes 9-6
hash join 2-66
import utility 5-38
MODIFY utility 2-293
online transaction optimization 10-71
ORDER BY clause 2-351
query execution, histograms 10-52
query optimization 10-66
row maintenance 10-75
SAMPLE statement, cluster
sampling 7-12
STORE BY clause 7-24
Physical name 6-13
PI function
examples of 8-130
syntax diagram of 8-130
PICTURE data type, character string 6-23
PICTURE data type, numeric 6-36
PM_OFFLINE_TRANSACTION_GRANULA
RITY default 10-64
PM_ONLINE_TRANSACTION_GRANULA
RITY default 10-64
POPULATE INDEX utility
examples of 2-306
syntax description 2-304
Populating indexes 2-85
POS
See Partition Overlay Specification
POSITION function
examples of 8-132
result of 8-131
syntax diagram of 8-131
POS_LOCATIONS default 10-65
POS_NUM_OF_PARTNS default 10-65
POS_RAISE_ERROR default 10-65
POWER function
examples of 8-132
syntax diagram of 8-132
Precision, description of 6-53
Predicates
summary of 6-85
, 6-105
BETWEEN 6-86
comparison 6-88
description of 6-85
EXISTS 6-92
IN 6-94
LIKE 6-97
NULL 6-99
quantified comparison 6-101
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-72
PREPARE statement
availability 2-300