SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-12
O
New process statistics 14-8
NO DEFAULT clause 7-30
NOAUDITCOMPRESS attribute 7-22
Node
remote, availability 13-13
Nodes
adding 13-24
altering 13-24
migrating for improved query plan
performance 11-14
removing 13-24
NonStop Server for Java
installing 3-4
NonStop Server for Java 4 1-12
NonStop Transaction Management Facility
(TMF)
See TMF
NOT NULL clause 7-30, 7-31
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
alternate setting 6-8
ANSI compliance 6-13
description of 6-4
NSM/web display of metadata 8-1
NULL clause 7-30
Null values 7-24, 7-30
NUMERIC data type columns 7-24
O
Object name resolution 11-10
Object namespaces 1-8
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-5
OPENS counter, Measure 14-8
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-33
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-42/8-43
restoring 12-23
PARTONLY option, BACKUP
command 5-33
PAX files 3-5
Performance
benchmarks 14-1