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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-3
C
Buffer 16-8
Buffer size, effect on query
performance 16-11
C
C preprocessor 3-23
Cache size 16-11
CACHE_HISTOGRAMS 6-7
CACHE_HISTOGRAMS_
REFRESH_INTERVAL 6-3, 6-7
CALLS counter, Measure 15-8
Capacity planning 14-3
CASCADE option 12-10
CAST function 7-22
Catalogs
adding 9-4
CATALOGS table, displaying contents
of 8-35
creating 7-6
dropping 9-29
querying metadata about 8-22/8-25
recovering 12-6
SCF ALTER DISK issues 12-36
SCF ALTER DISK, LABEL
issues 12-37
Changing the database 9-1, 9-18
Character data types 7-23
CLEARONPURGE attribute
altering index attributes 9-20
altering table attributes 9-24
Clustering keys
access paths 7-31
creating and using 7-12
example of 7-13
indexes 7-31
CMMXTOMPM file 3-17
COBOL preprocessor 3-23
Coexistence, SQL/MP and SQL/MX 14-2
Columns
adding 9-5
altering 9-23
Columns (continued)
data types 7-27
default value 7-28
dropping 9-29
indexed
benefits of 4-14
defining 4-16
KEYTAG 4-16
names 7-21
null value 7-28
performance issues 7-22
querying metadata about 8-49/8-57
renaming 4-11, 7-37
specifying attributes 7-30
specifying indexes 4-17, 4-18
values restriction 4-14
Compatibility issues for releases 13-26
Compilation statistics 15-8
Concurrency 16-2
Consistency 8-62
Consistent files, recovering 12-32
Constraints
adding 9-7
altering 9-24
changing 9-24
creating 7-35
dropping 9-30
performance issues 16-13
querying metadata about 8-46/8-48
restoring 12-23
CONTROL QUERY DEFAULT 6-2
COPYOSS macro 3-3
Correcting file label information 12-32
Correcting problem data 12-31
Corrupt bit, changing 12-33
CRASHOPEN option 12-2
Crash-open files, recovery 12-1
CREATE INDEX statement
adding an index 9-8
description of 4-17