SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-2
C
Comparison predicate
description of 1-31
multivalued 1-40
operators 1-31
COMPILE option 4-33
Composite table 3-34
Concatenation operator 1-20
Concurrency, optimizing 4-32
Conditional aggregates 1-45
Consistency 4-16
Constant expression 3-10
Constants, propagation of 3-10
Context-free servers 1-41
CONTROL EXECUTOR directive 4-13
CONTROL QUERY directive
BIND NAMES option 4-33
EXPLAIN plan and 6-13
HASH JOIN option 3-43
INTERACTIVE ACCESS option 4-6,
4-8
CONTROL TABLE directive
ACCESS PATH option 4-11, 5-20
buffering 4-28
CONTROL SEQUENTIAL READ
option 4-27
HASH JOIN SEQUENCE option 3-45
JOIN METHOD option 3-43, 5-20
JOIN SEQUENCE option 5-20
SEQUENTIAL option 4-28
using to force a path 4-8
using to override open-on-
demand 4-29
CONVERTTIMESTAMP function 1-24
Correlated references 1-29, 3-52
Correlated subquery
description of 1-29
EXPLAIN plan 6-13, 6-31
performance and 3-51, 5-14
Cost
data transfer 5-13
description of 5-11
Cost (continued)
DISPLAY STATISTICS command 6-3
evaluating 5-19
EXPLAIN plan and 6-12
how the optimizer determines 5-11
MDAM and 3-4, 5-17
messages 5-13
of indexes and predicates 5-16
of join operations 5-15
of sorts 5-14
physical I/O 5-12
record overhead 5-13
subqueries 5-14
table access 5-12
COUNT function 1-41
Cross product
description of 1-52
eliminating 3-35, 3-40
EXPLAIN plan for join 6-53
CURRENT function
description of 1-24
example of 1-25
Cursor operations
CLOSE statement and 1-12
closing 1-13
DECLARE CURSOR statement
and 1-12
effect on performance 4-28
EXPLAIN plan for
DELETE 6-73
UPDATE 6-72
FETCH statement and 1-12
FREE RESOURCES statement 1-13
initializing 1-12, 1-13
OPEN statement and 1-12
performance and 1-14
SELECT statement and 1-12