SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-22
P
P
PARALLEL_NUM_ESPS default 10-57
Parameter specification
examples of 6-78
names 6-77
type assignments 6-76
Parameters in dynamic SQL, restrictions on
use 2-164
PARTITION clause
examples 7-7
syntax diagram of 7-5
Partition Overlay Specification (POS)
default attributes 10-50
description of 2-90
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-57
CREATE TABLE, FIRST KEY
specification 2-84
Partitions
automatic creation 2-90
description of 6-82
hash 6-82
hash, MODIFY utility 5-49
managing 5-43
range 6-82
range, MODIFY utility 5-43, 5-45
PARTITIONS metadata table 10-19
Path name, CD command use of 4-7
Performance
buffer size 10-54, 10-55
character string data types 6-22
CLEARONPURGE file attribute 8-5
compound statements 3-14
constraint droppable options 10-39
constraints 2-22
CONTROL TABLE statement 2-48
CREATE TABLE and
DROPPABLE 2-78
DECLARE CURSOR statement 3-25
Performance (continued)
extent sizes 8-6
hash join 2-40
import utility 5-34
MODIFY utility 5-56
OLT_QUERY_OPT,
SHOWCONTROL 4-66
online transaction optimization 4-17,
10-56
ORDER BY clause 2-199
query execution, histograms 10-40
query optimization 10-53
row maintenance 10-60
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
PIC data type 6-20
PICTURE data type 6-34
POPULATE INDEX utility
examples of 5-71
syntax description 5-69
Populating indexes 2-59
POS
See Partition Overlay Specification
POSITION function
examples of 9-106
result of 9-105
syntax diagram of 9-105
POS_LOCATIONS default 10-52
POS_NUM_OF_PARTNS default 10-52
POS_RAISE_ERROR default 10-52
POWER function
examples of 9-107
syntax diagram of 9-107
Precision, description of 6-51