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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-13
O
NOT NULL clause 7-28, 7-29
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-22
NULL clause 7-28
Null values 7-21, 7-28
NUMERIC data type columns 7-22
O
Object name resolution 11-11
Object namespaces 1-8
Objects
altering 9-18
archiving 5-7
naming guidelines for 4-1
restoring 12-21
SCF ALTER DISK, LABEL
issues 12-37
ODBC A-1
OLTP 7-39
Online disk remirror feature 3-2
Online dumps 12-10
Online help
downloading from NTL 3-22
downloading from SUT 3-22
installing 3-21/3-23
OPEN SERVER command 2-5
OPENS counter, Measure 15-8
OR operator, improving performance with
index 4-18
Ordering rows using an index 4-18
OSS (Open System Services)
directory 3-9
environment 1-16, 3-7
installing 3-3
P
Parallel index maintenance 16-10
Parallel processing 1-5
Partially decoupling the clustering key and
partitioning key 7-15
Partitioned data 7-15
Partitioned tables, recovering 12-13
Partitioning key, creating and using 7-14
Partitions
adding 9-11, 16-14
altering 9-21
appending data 10-32
backing up 5-33
benefits of 9-11
broken, recovering 12-32
deleting data from 9-33
dropping 9-32, 16-14
local 13-23
moving 9-21, 10-19, 10-21, 16-14
performance benefits 16-14
querying metadata about 8-44/8-45
restoring 12-22
PARTONLY option, BACKUP
command 5-33
PAX files 3-7
Performance
benchmarks 15-1
column definitions 7-22
concurrency 16-2
data definitions 7-22
distributed databases 13-23
improving
description of 16-1
with index 4-18
improving with SQLMXBUFFER 16-8
index maintenance 16-10
indexes 4-12, 9-9
measuring 15-1/15-10
MODIFY utility 10-11