SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-7
M
Lock mode
description of 4-16
exclusive 4-19
shared 4-19
LOCK TABLE statement 4-19
Locks
access options 4-16
characteristics of 4-20
description of 4-16
duration of 4-16, 4-20
exclusive 4-19
EXPLAIN plan and 6-15
granularity of 4-19
mode 4-16, 4-19
shared 4-19
M
MAX function
description of 1-41
EXPLAIN plan for 6-70
optimizing 3-46
MDAM (MultiDimensional Access Method)
CONTROL QUERY directive 4-7
CONTROL TABLE directive 4-12
controlling the dense or sparse
algorithm 4-30
controlling the number of key
columns 4-30
cost
for a single predicate 5-17
for multiple predicate sets 5-18
for sparse or dense data 5-18
description of 3-4
EXPLAIN plan for 6-42, 6-43, 6-44
joins and 3-22
multiple tables in a query and 3-22
OR predicates and 3-22
plans that do not use 3-5
MDAM (MultiDimensional Access Method)
MDAM (MultiDimensional Access
Method) (continued)
predicates with missing key columns
and 3-16
range predicates on key columns
and 3-13
Messages, cost of 5-13
MIN function
description of 1-41
optimizing 3-46
Missing data, using left join to reveal 1-55
Multicolumn searches 3-19
Multiple predicate sets, EXPLAIN plan
for 6-46
Multiple-row SELECT statement 1-12, 3-60
Multistep queries 1-65
Multivalued predicate
description of 1-40, 3-4
performance implications of 3-19
N
Nested join method
description of 3-25
EXPLAIN plan for 6-51
NO RECOMPILE option, UPDATE
STATISTICS statement 4-3
Noncorrelated references 1-29, 3-53
Noncorrelated subquery
description of 1-29
EXPLAIN plan and 6-29
performance and 3-53
NOREGISTER option 4-33
Null augmentation for left join
description of 1-56
predicate evaluation and 1-60
NULL predicate 1-39
Null values 1-14
O
OCTET_LENGTH function 1-18