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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-23
LEFT_HYBRID_HASH_JOIN Operator
For information about setting the CONTROL QUERY DEFAULT attribute for
INSERT_VSBB, see the SQL/MX Reference Manual.
The INSERT_VSBB operator has no child nodes. The description field for this operator
contains:
LEFT_HYBRID_HASH_JOIN Operator
Join Group
The LEFT_HYBRID_HASH_JOIN operator returns an unmatched outer row even when
it does not find a match in the inner table. Null values are supplied for the missing inner
rows. The LEFT_HYBRID_HASH_JOIN operator differs from the
HYBRID_HASH_JOIN only when it does not find a match in the inner table. See
HYBRID_HASH_JOIN Operator on page 7-16.
The LEFT_HYBRID_HASH_JOIN operator has two child nodes. The description field
for this operator contains:
The example of the LEFT_HYBRID_HASH_JOIN operator is based on:
SELECT a.ten, max(a.unique2)
FROM abase a left join bbase b
ON a.unique2=b.unique3 WHERE a.tenpercent = 9
GROUP BY a.ten FOR READ UNCOMMITTED ACCESS;
3 5 6 left_hybrid_hash_join
hash_join_predicate:
(indexcol(\TESTSYS.$BIG18A.WISC32M.ABASE.UNIQUE2) =
indexcol(\TESTSYS.$BIG18A.WISC32M.IXB4.UNIQUE3))
join_type: left
join_method: hash
parallel_join_type: 1
Token Followed by ... Data Type
new_rec_expr Computation of the row to be
inserted
expr(text)
Token Followed by ... Data Type
join_type Inner, left, natural, inner semi,
or inner anti-semi-join
text
join_method Name of join method text
hash_join_predicate Expression of the join
predicates
expr(text)
parallel_join_type Type1 or Type2, depending
on parallel join algorithm
text
selection_predicates Expression of the selection
predicates
expr(text)