SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
Index-12
P
Objects
altering 9-18
archiving 5-7
naming guidelines for 4-1
restoring 12-22
SCF ALTER DISK, LABEL
issues 12-39
OLTP 7-41
Online dumps 12-10
Online help
downloading from NTL at
doc.hp.com 3-17
installing 3-17
OPEN SERVER command 2-4
OPENS counter, Measure 14-9
OR operator, improving performance with
index 4-18
Ordering rows using an index 4-18
OSS (Open System Services)
directory 3-6
environment 1-12, 3-6
installing 3-3
P
Parallel index maintenance 15-17
Parallel processing 1-5
Partially decoupling the clustering key and
partitioning key 7-16
Partitioned data 7-16
Partitioned tables, recovering 12-13
Partitioning key, creating and using 7-15
Partitions
adding 9-11
, 15-19
altering 9-21
appending data 10-39
backing up 5-32
benefits of 9-11
broken, recovering 12-33
deleting data from 9-32
dropping 9-31, 15-19
moving 9-21, 10-19, 10-21, 15-19
performance benefits 15-19
querying metadata about 8-51/??
restoring 12-23
, 12-24
PARTONLY option, BACKUP
command 5-32
PAX files 3-5
Performance
benchmarks 14-1
column definitions 7-24
concurrency 15-2
data definitions 7-24
distributed databases 13-23
improving
description of 15-1
with index 4-18
index maintenance 15-17
indexes 4-12, 9-9
measuring 14-1/14-11
MODIFY utility 10-11
OLTP 7-41
partitioning data 7-16, 15-19
partitions 9-11
queries 15-2
statistics 14-1
testing 9-9
tools for analyzing 14-1
VARCHAR columns 7-24
views 15-19
Periodic backup 5-31
Physical file structure 4-3
Platform.h file 3-7, 3-14
Post-installation tasks 3-15
Preinstallation tasks 3-2
PRESERVE_MIN_SCALE 6-4
Primary key
and null values 7-31
creating and using 7-13
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION