SQL/MX 2.x Installation and Management Guide (H06.04+)

Index
HP NonStop SQL/MX Installation and Management Guide—540436-001
Index-8
J
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-40/8-44
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-17
InstallSqlmx
command options 3-22
error messages 3-23
phases of 3-21
syntax 3-22
InstallSqlmx (continued)
using the script 3-20
Integrity, definitional 1-4
INTERACTIVE_ACCESS 6-3
Interface description files 3-15
Internal names, SQL objects 8-14
INTERVAL data type 7-27
INVALID attribute, TMF online
dumps 12-10
Invalid programs 14-8
ISO88591 6-8
ISOLATION_LEVEL, ANSI
compliance 6-12
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-5
clustering keys 4-5
description of 4-3
structure 4-5, 4-6
L
Label data
correcting 12-33
description of 12-27
Local autonomy 13-2, 13-12
Locally distributed database 13-1
Locks 14-9, 14-10