SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-11
C
Copying
data from Enscribe file to SQL
table C-113
data from SQL table to Enscribe
file C-113
Enscribe files
Correlated subqueries S-83
Correlation names C-128
Cost
of executing a statement D-52
of hash operation E-17
of sort operation E-19
of SQL operation, in EXPLAIN
report E-18
of total SQL statement E-20
COUNT function C-130
COUNT option
COPY command C-116
LOAD command L-21
CPARRAYENTRY in COLUMNS
table C-47
CPRLSRCE catalogs table C-131
CPROBJSIZE in CPRULES table C-131
CPRULES catalog table C-131
CPRULESNAME
in COLUMNS table C-47
in CPRLSRCE table C-131
in CPRULES table C-131
in KEYS table K-1
CPUS, parameter for FastSort Z-4
CREATE ASSERTION statement S-71
CREATE CATALOG statement
description of C-132
SECURE file attribute C-132
CREATE COLLATION statement C-137
CREATE CONSTRAINT statement
CHECK clause C-139
DEFERRED C-139
description of C-139
CREATE INDEX statement
AUDITCOMPRESS file attribute C-146
CATALOG clause C-144
COLLATE clause C-144
configuration file P-5
description of C-142
file attributes C-146
INVALIDATE clause C-144
KEYTAG option C-145
PARALLEL EXECUTION clause C-145
parallel index loading P-5
PARTITION clause C-145
PHYSVOL clause C-144
UNIQUE clause C-143
WITH SHARED ACCESS
clause C-146
CREATE statements and concurrent DML
operations C-65
CREATE SYSTEM CATALOG
command C-152
CREATE TABLE statement
AUDITCOMPRESS file attribute C-160
CATALOG option C-157
CLUSTERING KEY clause C-158
DEFAULT clause C-157, D-26
description of C-154
file attributes C-160
FORMAT file attribute C-161
HEADING clause C-157, H-1
LIKE clause C-155
NOT NULL clause C-157
ORGANIZATION clause C-158
PARTITION ARRAY clause C-159
PARTITION clause C-158
PHYSVOL clause C-158
PRIMARY KEY clause C-157
SECURE file attribute C-159
SIMILARITY CHECK clause C-160