SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-12
K
INDEXES catalog table, displaying
information 6-8
INDEXES EXPLICIT option
BACKUP command 4-18, 4-22
BACKUP utility 9-23
RESTORE utility 9-23
INDEXES IMPLICIT option
BACKUP command 4-22
BACKUP utility 9-23
DUP utility 9-23
RESTORE utility 9-23
INDEXES OFF option, DUP utility 9-19,
9-23
Index-only access 3-20
INFO DEFINE command 5-7
INITIALIZE SQL command 2-4, 2-6, 9-9
Initializing SQL/MP 2-4
Inoperable plan
compilation example 10-25
description 10-15
Insert operation, WITH CHECK 3-15
INSERT statement
ANYWHERE option 3-12
NOREGISTER Option 10-41
INSTALL program 2-2
Installation, SQL/MP 2-1, 2-2
INTEGER data type 5-22
Integrity
checks and constraints 5-52
definitional 1-6
INTERVAL data type 5-23/5-25
Invalid programs
compilation statistics 13-8
DDL operations 10-16, 10-18
DDL statements 10-1
detecting 10-4
listing 10-5
utility commands 10-1
INVOKE statement, DEFINEs 10-33
ISLACK option
APPEND command 8-16
ISLACK option (continued)
LOAD command 8-7
RELOAD command 8-3
Item names 5-19
K
KEEP target option 9-4
Key 3-6
Key prefix 3-22
Key tags, similarity check rules 10-27
Keys
See also User-defined primary key
clustering 3-2/3-3, 3-6, 5-11, 5-12
index 3-2, 3-19
levels 3-4
performance 3-4, 5-47
primary
definition 5-11
description 3-2
indexes 5-42
logical 3-2
null values 5-27
physical 3-2, 3-6
system-defined 3-3
SYSKEY column 3-3, 5-11
KEYS catalog table 6-8
KEYTAG column 3-19
Key-sequenced files
accessing 3-7
block size 5-15
clustering keys 3-6
description 3-1, 3-9
record length 5-15
structure 3-6, 3-8
Key-sequenced tables 3-4, 5-11