SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-16
P
Partitions (continued)
creating 7-7
displaying information 6-9
distributed databases 12-8
distributed systems 12-5
dropping 14-25
Format 2 2-11, 7-9, C-1/C-14
invalidating programs by adding 10-2
large quantities 5-34
loading, in parallel 8-9
local 12-9
lock limit 14-23
merging 7-20, 7-23
moving 7-20, 9-23
one-way split 7-21
performance benefits 7-7, 14-25
reorganizing 8-1, 8-5
restoring 11-3, 11-4
separate, loading 8-9
SMF 5-32
specifying 5-36
splitting 7-20, 8-2, 8-5
table organization 5-32
two-way splits 7-22
PARTONLY clause
altering partition attributes 7-19
description 7-16
PARTONLY MOVE option
ALTER INDEX statement 7-7, 7-20
ALTER TABLE statement 7-7, 7-20
PARTONLY option, BACKUP
command 4-21
Pathmaker application development
tool 5-28, 10-29
PATHMON, DEFINEs used 10-37
Paths, access
See Access paths
Performance
benchmarks 13-1
block size impact 14-24
Performance (continued)
catalog scheme 5-5
clustering keys 3-3
column definitions 5-20
concurrency 14-1
data definitions 5-20
distributed databases 12-9
evaluating with test database 14-12
generic locks 14-21
improving
by avoiding sort 3-21
overview 14-1/14-28
with DISTINCT clause 3-21
with GROUP BY clause 3-21
with index 3-21, 3-22
with ORDER BY clause 3-21
improving with index 3-21, 3-22
index maintenance 14-17
indexes 3-16
key levels 3-4
measuring 13-1, 13-8
partitioning data 5-32, 14-25
queries 14-1
recompilation 10-9
sort operations 14-26
statistics 13-1
tables and columns statistics 14-7
tools for analyzing 13-1
unique index keys 5-47
UPDATE STATISTICS 14-8, 14-10
VARCHAR columns 5-21
views 14-24
Periodic backup 4-20
Peripheral Utility Program
See PUP
PFS (Process file segment) 10-30
Physical file structure 3-1
Physical primary key 3-6