SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-8
P
ON clause
in join operations 1-59, 1-60
search conditions and 1-9
Online transaction processing (OLTP)
considerations 3-62
OPEN cursor statement 1-12
Operators for predicates 1-30
Optimization
See Performance
Optimizer
choosing an execution plan 2-3
determining cost with 5-11, 6-12
join strategy 3-34
OR operator
description of 1-35
optimizing 3-22
specifying indexes for improved
performance with 3-22
ORDER BY clause
EXPLAIN plan for 6-10, 6-25
of SELECT statement 1-4, 1-5
UNION operation and 1-63
using 3-54
with DISTINCT 3-58
with GROUP BY 3-57
Ordering rows, using the ORDER BY
clause 1-5
Outer join (left) operation 1-53, 1-55
Outer query 1-28
Outer SELECT 1-29
Outer table 3-25
P
Parallel execution, EXPLAIN plan and 6-15
Parallel processing of queries
CONTROL EXECUTOR directive 4-13
description of 4-13
EXPLAIN plan and 6-15
implementing 4-14
partitioning data for 4-14
Partitioned data
description of 4-14
for parallel processing of queries 4-14
Percent of all row values, computing 1-66
Performance
avoiding table scans 3-54, 4-4
considerations 3-1
cost comparisons of 6-12
efficient evaluation of predicates 3-4
gathering statistics about 6-2
IN optimization 3-7
keeping pertinent statistics on tables
and columns for 4-2
key predicates for 3-13
MIN and MAX optimizations 3-46
OR optimization 3-22
selecting columns for 3-2
sort 4-32
specifying block buffering for 4-28
specifying locking access options
for 4-17
specifying parallel execution of queries
for 4-13
types of subqueries for 3-51
using joins instead of subqueries
for 3-41
Physical design 4-1
Physical I/O, cost of 5-12
POSITION function 1-17
Predicate set
definition of 3-4
estimating cost
for a single 5-17
for multiple 5-18
processing 3-5
shown in EXPLAIN plan 3-6, 3-8, 3-49
transforming into 3-5
Predicates
aggregate functions and 1-41, 3-46
ALL 1-38