SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-23
P
OLT_QUERY_OPT default 10-62
Online transaction optimization (OLT)
OLT_QUERY_OPT 10-62
OPEN statement
C examples of 3-74
COBOL examples of 3-75
scope of 3-72
static and dynamic forms 3-72
syntax diagram of 3-72
OPTIMIZATION_LEVEL default 10-62
OPTS_PUSH_DOWN_DAM default 10-62
P
PARALLEL_NUM_ESPS default 10-62
Parameter specification
examples of 6-76
names 6-75
type assignments 6-74
Parameters in dynamic SQL, restrictions on
use 2-183
PARTITION clause
examples 7-7
syntax diagram of 7-5
Partition Overlay Specification (POS)
default attributes 10-54
description of 2-95
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-59
CREATE TABLE, FIRST KEY
specification 2-89
Partitions
automatic creation 2-95
description of 6-80
hash 6-80
hash, MODIFY utility 5-76
limits C-1
managing 5-68
range 6-80
range, MODIFY utility 5-68, 5-70
PARTITIONS metadata table 10-20
Path name, CD command use of 4-7
Performance
buffer size 10-59
character string data types 6-22
CLEARONPURGE file attribute 8-5
compound statements 3-14
constraint droppable options 10-42
constraints 2-22
CONTROL TABLE statement 2-50
CREATE TABLE and
DROPPABLE 2-83
DECLARE CURSOR statement 3-25
extent sizes 8-6
hash join 2-42
import utility 5-46
MODIFY utility 5-85
online transaction optimization 10-62
ORDER BY clause 2-218
query execution, histograms 10-43
query optimization 10-57
row maintenance 10-66
SAMPLE statement, cluster
sampling 7-11
STORE BY clause 7-23
Physical name 6-13
PI function
examples of 9-108
syntax diagram of 9-108
PICTURE data type, character string 6-21
PICTURE data type, numeric 6-34
PM_OFFLINE_TRANSACTION_GRANULA
RITY default 10-55
PM_ONLINE_TRANSACTION_GRANULA
RITY default 10-55
POPULATE INDEX utility
examples of 5-110
syntax description 5-108
Populating indexes 2-61
POS
See Partition Overlay Specification