SQL/MP Query Guide

HP NonStop SQL/MP Query Guide—524488-003
Index-1
Index
A
Access option 4-16
Access path
alternate index 4-5
base table, through an index 4-6
description of 4-4
displaying with EXPLAIN 6-13
index-only 4-6
primary key 4-5
table scan 4-4
Aggregate functions
AVG 1-41
CASE and 1-45
conditional 1-45
COUNT 1-41
description of 1-41
evaluating 3-46, 3-47, 6-83
MAX 1-41
MIN 1-41
optimizing 3-46
SUM 1-41
ALL predicate 1-38
ANY predicate 1-38
Assignment, processor 2-5
AVG function 1-41
B
Base table
accessing through an index 4-6
accessing through primary key 4-5
predicate 3-14
scanning 4-4
Batch processing considerations 3-63
Begin key 1-32
BEGIN WORK statement 4-2
Begin-key predicate 3-13
BETWEEN predicate 1-32
Blocks, buffering of 4-28
Bounded predicate, EXPLAIN plan for 6-20
Bounded search 1-32
Browse access
for long-running queries 4-18
options 4-16
Buffering mode
description of 4-21
effect of cursor operations on 4-28
how the optimizer chooses 4-21
real sequential 4-23
single row 4-22
virtual sequential 4-24
Build phase of hash-join method 3-30
C
Cartesian product
description of 1-52
eliminating 3-35, 3-40
CASE expression
description of 1-43
EXPLAIN plans for 6-33
for computing aggregates on specific
conditions 1-45
for converting tables 1-49
for decoding values 1-43
for finding the highest value 1-47
for ignoring largest and smallest
values 1-51
for use with multiple conditions 1-44
CHAR_LENGTH function 1-18
CHECK option 4-33
CLOSE cursor statement 1-12, 1-13
Columns
listed in SELECT statement 1-2
projecting 1-3
selecting with faster access 3-2
COMMIT WORK statement 4-2