SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-10
R
Query execution plan (continued)
generating 6-9
interpreting 6-12
Query optimization
See also Performance
CONTROL EXECUTOR directive 4-13
CONTROL TABLE directive 4-28
cursor operations and 4-28
formulating queries for 3-1
keeping statistics current for 4-2
specifying appropriate access type
for 4-17
specifying buffered operations for 4-28
Query Rewrite
description of 3-9
for propagating constants 3-10
left joins and 3-9, 6-66, 6-68
using 3-8
R
Range predicate
description of 1-32
MDAM and 3-13
performance implication of 3-13
selectivity 5-3
Read-only access 4-16
Real sequential block buffering (RSBB)
See RSBB
Recompilation 4-3
Record overhead, cost of 5-13
References
correlated 1-29, 3-52
noncorrelated 1-29, 3-53
REGISTERONLY option 4-33
Repeatable access 4-16, 4-17
Restriction of rows 1-4
Retrieving data
See Data, retrieval
ROLLBACK WORK statement 4-2
Rows
computing value as percent of all 1-66
eliminating duplicate 1-6
grouping for aggregate functions 1-7
null-augmented 1-56
ordering 1-5
restricting 1-4
selecting 1-2, 1-10
Row-at-a-time select 1-12
RSBB (Real sequential block buffering)
description of 4-23
how the optimizer chooses 4-24
S
SBB (Sequential block buffering)
EXPLAIN plan and 6-14
real 4-23
virtual 4-24
Search conditions
description of 1-8
predicates in 1-30
WHERE clause and 1-9
Searching databases 1-8
SELECT statement
and cursors 3-60
as used in programs 1-10
cursor operation 1-12
DISTINCT clause 1-6
for retrieving data 1-2
GROUP BY clause 1-7
IN EXCLUSIVE MODE option 4-19
IN SHARE MODE option 4-19
inner query 1-28
INTO clause and host variables 1-11
multiple-row 1-12, 3-60
ORDER BY clause 1-5
outer query 1-28
row-at-a-time 1-12
select list in 3-2