SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-24
P
syntax diagram of 7-6
Partition Overlay Specification (POS)
default attributes 10-63
description of 2-115
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-74
CREATE TABLE, FIRST KEY
specification 2-109
Partitions
automatic creation 2-115
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-24
Path name, CD command use of 4-8
Performance
buffer size 10-68
character string data types 6-24
CLEARONPURGE file attribute 8-5
compound statements 3-14
constraint droppable options 10-51
constraints 2-26
CONTROL TABLE statement 2-65
CREATE TABLE and
DROPPABLE 2-101
DECLARE CURSOR statement 3-25
extent sizes 8-6
hash join 2-57
import utility 5-55
MODIFY utility 5-91
online transaction optimization 10-70
ORDER BY clause 2-263
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 9-125
syntax diagram of 9-125
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 5-119
syntax description 5-117
Populating indexes 2-76
POS
See Partition Overlay Specification
POSITION function
examples of 9-127
result of 9-126
syntax diagram of 9-126
POS_LOCATIONS default 10-65
POS_NUM_OF_PARTNS default 10-65
POS_RAISE_ERROR default 10-65
POWER function
examples of 9-127
syntax diagram of 9-127
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