SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-1
Index
A
Accelerator, effect on SQL validity 10-1
Access improvement
defining numeric columns 5-21
defining VARCHAR columns 5-21
Access paths
alternate 5-42
distributed database 12-5
distributed systems 12-5
EXPLAIN utility 10-12
primary keys 3-2, 5-42
statistics issues 14-8
unavailable 10-13
Access plan
See Query execution plan
Active dictionary
See Data dictionary
ADD COLUMN clause 5-19, 7-10
ADD CONSTRAINT statement, program
invalidation 10-16
ADD DEFINE command 10-34
ADD PARTITION option 7-7
ALLOCATE file attribute, similarity check
rules 10-28
Allocating space for tables 5-14
ALLOWERRORS clause 7-35
ALTER CATALOG statement
altering objects 7-14
altering security 2-6
description 7-15
ALTER COLLATION statement 7-27
ALTER INDEX statement
ADD PARTITION option 7-7
altering objects 7-14
altering partition attributes 7-19
description 7-19
PARTONLY MOVE option
adding partitions 7-7, 7-9
ALTER INDEX statement (continued)
splitting or moving partitions 7-20
renaming objects 7-36
ALTER PROGRAM statement, altering
security 2-8
ALTER TABLE statement
ADD PARTITION option 7-7
altering partition attributes 7-19
altering security 2-6
defining columns 5-19
description 7-15/7-16
example 7-10
PARTONLY MOVE option 7-7, 7-20
program invalidation 10-16
renaming objects 7-36
securing catalog tables 5-7
securing tables 5-37
ALTER VIEW statement
altering objects 7-14
description 7-18
program invalidation 10-16
renaming objects 7-36
Altered execution plans 10-25
Alternate access path 5-42
APPEND option, COPY utility 8-13
APPEND utility
adding data 8-15
compared to LOAD 8-15
DSLACK option 8-16
guidelines 8-15
ISLACK option 8-16
options 8-16
partitions 8-16
PARTONLY option 8-15
SLACK option 8-16
Applications
description 1-1
environment 1-1