SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-11
G
FUP (File Utility Program) (continued)
SECURE command 2-8
SQLCI2 license A-1
STATUS command 8-4
SUSPEND command 8-4
G
Generic locks 14-21
GET CATALOG statement 10-41
GET VERSION OF PROGRAM
statement 10-13, 10-41
GROUP BY clause, avoiding sort 3-21
Group manager, security issues 4-4
Guardian names, resolution 10-13
H
Hardware
changing or moving 13-1
requirements 2-1
HEADING attribute 5-28, 10-29
HELP TEXT
attribute 5-28, 10-29
statement 7-16
Help text
COMMENTS table 6-7
similarity check rules 10-28
High PINs, as default 2-13
HIGHPIN attribute 2-13
I
Identifiers as DEFINE names 10-30
INCLUDE SQLSA statement 13-4
INCOMPLETE SQLDDL OPERATION
flag 7-24
Indexed columns
benefits 3-18
defining 3-20
integrity checking 5-47
Indexes
adding 7-4
altering attributes 7-19
AUDIT attribute 4-15
backing up 4-22
catalog tables 5-3
column data type and performance 3-4
creating 5-42/5-47, 7-4
description 1-2
displaying information 6-8
distributed databases 12-7
dropping 7-31
frequently used columns 3-20
improving performance
access path 14-16
aggregate functions 3-22
benefits 7-4
description 3-16
OR operations 3-22
sort operations 3-21
invalidating programs by creating 10-2
keys 3-2
levels 13-2, 14-7
loading 8-8
local partitions 12-9
moving 9-14, 9-22
ordering rows 3-21
parallel maintenance 14-17
partitioning 14-25
PHYSVOL option 5-45
primary key 3-19
renaming 7-36
restoring 11-6
retaining slack 4-18
securing 5-37
security dependencies on tables 4-5
swap files 5-44
unique 3-18, 5-47
unique keys and performance 5-47