SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-24
P
Partitioning key (continued)
CREATE TABLE, FIRST KEY
specification 2-88
Partitions
automatic creation 2-94
description of 6-83
hash 6-83
hash, MODIFY utility 5-80
limits C-1
managing 5-72
range 6-83
range, MODIFY utility 5-72, 5-74
PARTITIONS metadata table 10-22
Path name, CD command use of 4-8
Performance
buffer size 10-65
character string data types 6-24
CLEARONPURGE file attribute 8-5
compound statements 3-14
constraint droppable options 10-48
constraints 2-22
CONTROL TABLE statement 2-48
CREATE TABLE and
DROPPABLE 2-81
DECLARE CURSOR statement 3-25
extent sizes 8-6
hash join 2-40
import utility 5-50
MODIFY utility 5-89
online transaction optimization 10-67
ORDER BY clause 2-219
query execution, histograms 10-49
query optimization 10-63
row maintenance 10-72
SAMPLE statement, cluster
sampling 7-11
STORE BY clause 7-23
Physical name 6-13
PI function
examples of 9-112
PI function (continued)
syntax diagram of 9-112
PICTURE data type, character string 6-23
PICTURE data type, numeric 6-36
PM_OFFLINE_TRANSACTION_GRANULA
RITY default 10-61
PM_ONLINE_TRANSACTION_GRANULA
RITY default 10-61
POPULATE INDEX utility
examples of 5-114
syntax description 5-112
Populating indexes 2-59
POS
See Partition Overlay Specification
POSITION function
examples of 9-114
result of 9-113
syntax diagram of 9-113
POS_LOCATIONS default 10-62
POS_NUM_OF_PARTNS default 10-62
POS_RAISE_ERROR default 10-62
POWER function
examples of 9-114
syntax diagram of 9-114
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
LIKE 6-97
NULL 6-99
quantified comparison 6-101
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-68
PREPARE statement
availability 2-184
C examples of 2-186
COBOL examples of 2-187