SQL/MX 2.x Installation and Management Guide (H06.04+)

Index
HP NonStop SQL/MX Installation and Management Guide—540436-001
Index-12
O
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 Technical Library (NTL) 3-17
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-12
description of 6-4
NSM/web display of metadata 8-1
NTL Web site 3-17
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 3-18
Online help (continued)
downloading from SUT 3-18
installing 3-17/3-18
OPEN SERVER command 2-4
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-34
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-45/8-46
restoring 12-23
PARTONLY option, BACKUP
command 5-33
PAX files 3-5
Performance
benchmarks 14-1
column definitions 7-24