Neoview Query Guide (R2.3, R2.4, R2.5)

NESTED_ANTI_SEMI_JOIN Operator
The NESTED_ANTI_SEMI_JOIN operator describes a portion of an execution plan that involves
a nested join. This operator returns all rows from the inner table that do not satisfy the predicates.
See “NESTED_JOIN Operator” (page 25).
The NESTED_ANTI_SEMI_JOIN operator has two child operators. The description field for this
operator contains:
Data TypeToken DescriptionToken
integerA sequential number assigned to the fragment. 0 is always master
executor and 1 is reserved for the Explain plan. Numbers 2 to n will be
ESP or DAM fragments.
fragment_id
integerThe fragment_id for the parent fragment of the current fragment. Value
is (none) for master executor.
parent_frag
textmaster, ESP, or DAMfragment_type
textInner anti-semi, left anti-semi, or natural anti-semi joinjoin_type
textName of join method: nested or in-order nestedjoin_method
text1 for Type1 or 2 for Type2, depending on parallel join algorithmparallel_join_type
expr(text)Expression of the ON clause that has not been pushed down to the inner
scan, typically empty
join_predicate
expr(text)Expression of the WHERE clause that has not been pushed down to the
inner scan, typically empty
selection_predicates
LEFT_NESTED_JOIN Operator
The LEFT_NESTED_JOIN operator describes a portion of an execution plan that involves a nested
join. The LEFT_NESTED_JOIN sends each outer (left) row to the inner (right) child. The right
child finds all the matches for a row and returns all the matches. If an outer row finds no matches
in the inner table, the outer row is returned, and nulls are supplied for inner table values. See
“NESTED_JOIN Operator” (page 25).
The LEFT_NESTED_JOIN has two child operators. The description field for this operator contains:
Data TypeToken DescriptionToken
integerA sequential number assigned to the fragment. 0 is always master executor
and 1 is reserved for the Explain plan. Numbers 2 to n will be ESP or DAM
fragments.
fragment_id
integerThe fragment_id for the parent fragment of the current fragment. Value
is (none) for master executor.
parent_frag
textmaster, ESP, or DAMfragment_type
textLeft joinjoin_type
textName of join method: nested or in-order nested joinjoin_method
text1 for Type1 for 2 or Type2, depending on parallel join algorithmparallel_join_type
expr(text)Expression of the ON clause that has not been pushed down to the inner
scan, typically empty
join_predicate
expr(text)Expression of the WHERE clause that has not been pushed down to the
inner scan, typically empty
selection_predicates
26 Query Plan Operators