SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-5
C
Columns (continued)
deleting 7-33
displaying information 6-7
indexed
benefits 3-18
defining 3-20
integrity checking 5-47
invalidating programs by adding 10-2
KEYTAG 3-19
masking 3-15
names 5-19
null value 5-26
performance issues 5-20
renaming 3-14, 5-38
specifying attributes 5-28
specifying indexes 3-20, 3-21
values restriction 3-18
COLUMNS catalog table, displaying
information 6-7
Comments
adding 7-13
altering 7-28
changing 7-28
clearing 7-28, 7-35
displaying 6-7
dropping 7-35
similarity check rules 10-28
COMMENTS catalog table, displaying
information 6-7
COMMIT WORK statement 4-16, 14-10
COMPACT option, COPY utility 8-13
Compatibility issues for releases 2-1, 12-17
COMPILE INOPERABLE PLANS
option 10-24, 10-25
COMPILE INVALID PLANS option 10-24
COMPILE PROGRAM option 10-23
Compiled statements, estimated cost 13-3
Concurrency 5-5, 14-1
Consistency
FILCHECK utility 6-14
locks 4-10
VERIFY utility 6-12
Constraints
adding 7-12
altering 7-27
changing 7-27
creating 5-52, 7-12
defining 5-51
description 5-51
displaying information 6-6
dropping 7-34
effect on data dictionary 1-4
invalidating programs by creating 10-2
performance issues 14-23
CONSTRNT catalog table
description 5-53
displaying information 6-6
CONTROL QUERY BIND NAMES
directive 10-36, 10-42
CONTROL TABLE statement 14-23
CONVERT utility 8-7
COPY utility
APPEND option 8-13
appending rows 8-7
COMPACT option 8-13
compared to LOAD 8-7, 9-3
moving data 8-7
moving tables
description 9-16
example 9-20
moving a database 9-23
operations 9-2, 9-3
reorganizing tables 8-2
restructuring database 8-1
rules 8-13
CRASHOPEN option 11-13
Crash-open files, recovery 11-12