SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-6
J
INSERT statement
EXPLAIN plan for 6-74
for modifying data 1-2
INSERT-SELECT, EXPLAIN plan for 6-75
Integrity of data 4-16
INTERVAL data type 1-21, 1-22
INTO clause 1-11
J
Join methods
See also Join operation
See also Join predicate
evaluation by optimizer 3-34
hash join 3-30
key-sequenced merge join 3-27
nested join 3-25
relative performance 3-36
sort merge join 3-25
Join operation
cost of 5-15
description of 1-51
evaluating 3-24
EXPLAIN plans for 6-48
inner 1-53, 1-54
left (outer) 1-53, 1-55
methods comparing 3-36
outer 1-53, 1-55
queries for 1-51
restrictions 1-59
selectivity 5-10
self join 3-42
using instead of subquery 3-41
writing efficient joins for 3-39
Join predicate
Cartesian product and 3-35, 3-40
cross product and 3-35
description of 1-51
performance implications of 3-40
specifying 3-18
Join predicate (continued)
widening choice of execution plans
with 3-41
Join query
See also Join operation
faster execution with Query
Rewrite 3-8
transformations related to 3-8
JULIANTIMESTAMP function 1-24, 1-27
K
Key predicate
description of 3-13
examples 3-17
EXPLAIN plan for 6-13, 6-23
specifying for better performance 3-13,
3-16
with multiple columns 3-18
Key prefix 3-7
Key-sequenced merge join
description of 3-27
EXPLAIN plan for 6-60, 6-62
L
Left join operation
description of 1-53, 1-55
EXPLAIN plan for 6-64, 6-66
hierarchical relationships and 1-57
null augmentation and 1-56
preserved data and 1-53, 1-56
revealing missing data 1-55
transforming to inner join 3-9
LIKE predicate
See also Predicates, LIKE
constant propagation and 3-10
description of 1-33
with wild-card characters 1-34
LOAD command 6-76