Neoview Query Guide (R2.2)
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 operator for a COMPOUNDSTMT operator is always COMPOUNDSTMT. 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.
EXPLAIN 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>.
64 Query Plan Operators