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

TRANSPOSE Operator
The TRANSPOSE operator occurs as a result of a TRANSPOSE clause. It can also occur due to
an internally generated GROUPBY clause. You might see this operator if you have multiple
distinct aggregates in the query.
The TRANSPOSE operator has one child. 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
ItemExpr treeRepresentation of a transpose set of the transpose clause. If multiple
transpose sets, then multiple instances of the token.
transpose_union_vector
Union Operators
MERGE_UNION Operator
The MERGE_UNION operator describes the part of an execution plan that merges rows from
two child operators.
The MERGE_UNION 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
textSort order of the result of the unionsort_order
expr(text)Expression used to determine which child operator to read from next:
read from left if true, or read from right if false
merge_expr
textMergeunion_type
expr(text)Expression used for conditional union. Occurs with IF statements in
a compound statement
condExpr
expr(textExpression used for trigger exceptionstrigExceptExpr
50 Query Plan Operators