SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Query Guide—523728-003
Index-5
Q
operator 8-2
Parallelism (continued)
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-38
Performance
full table scan 2-5
hash join 8-10
index impact 2-2
MDAM 2-12
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-5, 6-1
reduced response time 3-4
row vs. cluster sampling 3-6
sampling techniques 3-5
sampling tradeoffs 3-6
UPDATE STATISTICS 3-5
use measure data 4-22
Physical operators 1-3, 1-5, 5-9
Pipelined parallelism 8-2
Plan
See Query execution plan
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-15
OR 2-15
OR operators in 1-10
range 2-15
redundant and contradictory 2-16
Principle of optimality 1-4
Q
Query compilation 1-1
Query execution plan
as data flow tree 8-2
cost factors 4-4
displaying 5-2
examples of 4-5, 4-6, 4-13
forcing new shape 5-1
reviewing 5-3
troubleshooting 5-10
Query plan caching
cacheable queries 6-2
description 6-1
noncacheable queries 6-4
overview of 6-1
sizing 6-6
Query tree
compiler 1-2
Queues 1-14