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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-8
J
import (continued)
running on populated tables 10-28
Inconsistencies, detecting 8-60
Independent products
software 2-3
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
benefits of 9-8
description of 4-12
OR operations 4-18
sort operations 4-18
ordering rows 4-18
parallel maintenance 15-17
partitioning 15-19
primary key 4-16
querying metadata about 8-37/8-41
restoring 12-24
unique 4-14
Index-only access 4-17
INDEX_ELIMINATION_LEVEL 6-3
INFO command, mxtool
description of 12-26
Guardian files 8-3, 12-31
INITIALIZE DISK command, SCF 12-39
Installing SPRs for H-series RVUs 3-3
Installing Visual Query Planner 3-16
InstallSqlmx
command options 3-21
InstallSqlmx (continued)
error messages 3-22
phases of 3-19
syntax 3-21
using the script 3-18
Integrity, definitional 1-4
INTERACTIVE_ACCESS 6-3
Interface description files 3-14
Internal names, SQL objects 8-11
INTERVAL data type 7-27
INVALID attribute, TMF online
dumps 12-10
Invalid programs 14-8
ISO88591 6-8
ISOLATION_LEVEL, ANSI
compliance 6-13
Item names 7-23
J
JDBC/MX driver
description of 1-13
installation 3-4
K
Key prefix 4-18
Keys
clustering, indexes 7-33
index 4-16
primary, null values 7-31
KEYTAG column 4-16
Key-sequenced files
accessing 4-6
clustering keys 4-5
description of 4-3
structure 4-5, 4-6
L
Label data
correcting 12-33