Neoview Query Guide (R2.3, R2.4, R2.5)
Operators Appearing Infrequently or Not At All
COMPOUNDSTMT Operator
The COMPOUNDSTMT operator describes a portion of an execution plan that involves a
compound statement. It also can appear as a by-product of a triggers operation. A compound
statement that has n-statements will have n-1 COMPOUNDSTMT operators. This operator
enables bundling several statements together as one single atomic statement and allows data to
flow from one child to the other. The children of a compound statement operator are executed
serially. The left child is executed first, data is sent to the right child, and then the right child is
executed.
The COMPOUNDSTMT 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
integerSize of messages bufferbuffer size
EXPLAIN Operator
The EXPLAIN operator executes a stored function.
The EXPLAIN operator has no 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
expr(text)Parameters from the call to the EXPLAIN functionfunction_parameters
PACK Operator
Use the PACK operator in a query plan when selecting rows into rowset arrays:
SELECT <list> INTO <list of arrays> <body of query>
The PACK operator collects all the rows coming from the body of the query and puts them into
the arrays in the <list of arrays>.
Operators and Description Fields 53