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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-8
H
GOAWAY command, mxtool
damaged objects 12-35
description of 12-25
Guardian files
physical names 1-7
retrieving information 12-30
H
Hardware
changing or moving 15-1
requirements 2-2, 14-1
Header files 3-18
HEADING attribute 7-30
HIST_NO_STATS_REFRESH_
INTERVAL 6-3
HIST_SCRATCH_VOL 6-7
HIST_SECURITY_WARNINGS 6-3
I
IEEE floating point 14-1
import
appending data 10-33
to multiple partitions in
parallel 10-32
to tables 10-31
command options 10-22
DataLoader/MX use of 14-14, 14-15
guidelines for loading and appending
data into tables 10-22
loading partitions 10-28
managing constraints 10-27
managing indexes 10-27
managing partitions 10-26
managing triggers 10-27
running on empty tables 10-24
running on populated tables 10-25
Inconsistencies, detecting 8-62
Independent products
installing during fallback A-7
software 2-4
Indexed columns
benefits of 4-14
defining 4-16
Indexes
adding 9-8
altering 9-20
benefits of 9-9
creating 7-31, 9-8
dropping 9-31
EXPLAIN 9-10
frequently used columns 4-17
improving performance
access path 16-10
aggregate functions 4-18
benefits of 9-8
description of 4-12
OR operations 4-18
sort operations 4-18
local partitions 13-23
ordering rows 4-18
parallel maintenance 16-10
partitioning 16-14
primary key 4-16
querying metadata about 8-39/8-43
restoring 12-23
unique 4-14
Index-only access 4-17
INDEX_ELIMINATION_LEVEL 6-3
INFO command, mxtool
description of 12-25
Guardian files 8-3, 12-30
INITIALIZE DISK command, SCF 12-38
INSERT...SELECT statement 14-15
Installation planning 14-3
Installing Visual Query Planner 3-21
InstallSqlmx
command options 3-27
error messages 3-28
phases of 3-25
syntax 3-27