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

The LEFT_ORDERED_HASH_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
textLeft joinjoin_type
textName of join method: hashjoin_method
text1 for Type1 or 2 for Type2, depending on parallel join algorithmparallel_join_type
expr(text)Expression of the join predicatehash_join_predicate
expr(text)List of values that cause the hash table to be rebuilt when values
change
reuse_comparison_values
expr(text)Expression of the join predicatejoin_predicate
expr(text)Expression of the WHERE clause that is not included in a
hash_join_predicate or one of the child scans
selection_predicates
ORDER_CROSS_PRODUCT
The ORDER_CROSS_PRODUCT operator forms a cross product of the data from two child tables.
This operator preserves the order of both the outer and inner tables and does not overflow to
disk. This operator is chosen only if the inner table is small enough to fit in memory, and no join
or selection predicates exist. Used only for joining dimension tables in a star schema.
The ORDER_CROSS_PRODUCT 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 or natural joinjoin_type
textName of join method: hashjoin_method
text1 for Type1 or 2 for Type2, depending on parallel join algorithmparallel_join_type
Insert Operators
INSERT Operator
The INSERT operator describes the part of an execution plan that inserts a new row into a table.
34 Query Plan Operators