SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
Index-5
Q
Parallelism
combining different types 8-12
degree of 8-21
EXPLAIN output 8-12
forcing plans with 5-13
group by 8-11
how optimizer avoids repartitioning 8-8
independent 8-2
influencing 8-24
insert 8-12
matching partitions algorithm 8-6
multilevel 8-12
operator 8-2
parallel access to inner table 8-10
parallel joins 8-8
partitioned 8-1
pipelined 8-2
plan fragments 8-16, 8-21
recognizing in plans 8-13
relationship of ESPS to CPUs 8-24
scans 8-6
select 8-12
sort 8-12
system default settings 8-25
tokens in EXPLAIN output 8-16
unions 8-11
PARALLEL_NUM_ESPS system default
setting 8-26
Parser 1-2
Partitioned parallelism 8-1
Partitions, influencing parallelism with 8-24
PARTITION_ACCESS operator 7-57
Performance
full table scan 2-5
hash join 8-10
index impact 2-2
MDAM 2-13
negative impact of CONTROL QUERY
SHAPE 5-1, 5-13
nested join algorithm 8-10
OLT optimization 1-8
OLTP tips 1-7
OR optimization 1-10
query plan caching 1-6, 6-1
reduced response time 3-4
row vs. cluster sampling 3-7
sampling techniques 3-5
sampling tradeoffs 3-7
UPDATE STATISTICS 3-5
use measure data 4-23
Physical operators 1-3, 1-5, 5-9
Pipelined parallelism 8-2
Plan fragment
degree of parallelism 8-21
description of 8-3
in EXPLAIN output 8-16
multiple instances of 8-4
process boundaries 8-3, 8-19
recognizing 8-17
Predicates
missing key 2-16
OR 2-16
OR operators in 1-10
range 2-16
redundant and contradictory 2-17
Principle of optimality 1-4
Q
Query compilation 1-1
Query execution plan
as data flow tree 8-2
displaying 5-2
examples of 4-5, 4-6, 4-14
forcing new shape 5-1
reviewing 5-3
troubleshooting 5-10
Query plan caching
cacheable queries 6-2
description 6-1
TP663851.fm Page 5 Monday, October 17, 2011 11:48 AM