SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-15
O
NORECOMPILE option
CHECK options 10-22
UPDATE STATISTICS statement 14-9
NOREGISTER option
example 10-42
RESTORE SQLCOMPILE option 10-43
SQL compiler listing 10-40
NOREGISTER option, similarity check
rules 10-41
NOT NULL clause 5-27
NULL clause 5-26
Null values 5-20, 5-26
Number of columns, similarity check
rules 10-28
Number of indexes, similarity check
rules 10-27
Numeric columns, defining for faster
access 5-21
NUMERIC data type
columns 5-20
DEFAULT SYSTEM clause 5-27
defining 5-22
O
OBEY command files
database recovery 4-24
entering DEFINEs 10-31
licensed SQLCI process 9-13
VERIFY utility output 10-5
Object programs 10-7
Objects
adding 7-1
archiving 4-18
backing up with AUDITED option 9-34
dependencies 6-1
distributed 12-1, 12-8
dropping 7-28, 12-8
moving 9-14
name resolution 10-13
PUP LABEL issues 11-31
Objects (continued)
purging 7-35
renaming 7-36
restoring 11-2
Online database reorganization 8-2
Online dump
description 4-11
move procedure 9-14
Online recovery 4-10
Open invalidation 10-1
OPENS counter, Measure 13-9
Operable plan 10-15
Operating system software,
requirements 2-1
OR operator, improving performance with
index 3-22
ORDER BY clause, avoiding sort 3-21
Ordering rows using an index 3-21
OSS environment 1-9
OWNER file attribute, similarity check
rules 10-28
Ownership
changes 4-5
server 10-29
shorthand view 5-40
P
Parallel execution plans, similarity
check 10-16
Parallel index maintenance 14-17
Partition array type 5-16
Partition node array 10-25
Partitioned data 5-32
Partitioning attributes, similarity check
rules 10-27
Partitions
adding 7-7, 14-25
altering attributes 7-16, 7-19
appending data 8-15, 8-16
backing up 4-21
boundaries, moving 7-20, 7-22