SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
Index-7
G
SQL/MX 3-8
structure 4-3, 4-5
FILE, Measure entity
access costs 14-11
description of 14-6
statistics 14-7
FIRST KEY clause 7-32
FIXUP command, mxtool
broken objects 12-32
description of 12-26
examples of 12-20, 12-21, 12-35
timestamps 12-11
FLOAT data type 7-26
FLOATTYPE 6-3
FUP
RELOAD command 10-2
STATUS command 10-3, 10-4
SUSPEND command 10-4
Using RELOAD to generate more
accurate query plans 15-17
G
GOAWAY command, mxtool
damaged objects 12-37
description of 12-26
Guardian files
physical names 1-7
retrieving information 12-32
H
Hardware
changing or moving 14-1
requirements 2-1
HASHPARTFUNC function 7-18
Header files 3-14
HEADING attribute 7-32
HIST_SCRATCH_VOL 6-3
I
import
appending data 10-39
to multiple partitions in
parallel 10-39
to tables 10-38
command options 10-23
examples of loading SQL/MX
tables 10-33
/10-34
format file considerations 10-25
guidelines for loading and appending
data into tables 10-22
input file considerations 10-25
loading partitions 10-30
managing constraints 10-29
managing indexes 10-30
managing partitions 10-28
managing triggers 10-30
running on empty tables 10-27
running on populated tables 10-28
Inconsistencies, detecting 8-69
Independent products
software 2-3
Index
restoring 12-24
Indexed columns
benefits of 4-14
defining 4-16
Indexes
adding 9-8
altering 9-20
benefits of 9-9
creating 7-33, 9-8
dropping 9-30
EXPLAIN 9-9
frequently used columns 4-17
improving performance
access path 15-16
aggregate functions 4-18