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

The SEQUENCE operator has one child operator. 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 the history buffer (in rows). This number of rows is kept in a
buffer and is available for access by the sequence functions. Any
access to a row outside this buffer results in a NULL value. The default
value for this parameter is 1024 rows.
num_history_rows
integerSize of each history row in the history buffer.history_row_size
expr(text)List of column references specifying the ordering required by the
SEQUENCE operator. Obtained from a list of columns specified in
the SEQUENCE BY clause.
required_order
ItemExpr treeRepresentation of the list of sequence functions that must be evaluated
by this SEQUENCE operator.
sequence_functions
textColumns in the select list that are being sequencedsequence_columns
TUPLELIST Operator
The TUPLELIST operator shows the values that you place in the query when the VALUES clause
is used. This operator occurs when queries have a large in-list of literal values. 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)The tuple produced by this operatortuple_expr
VALUES Operator
The VALUES operator calculates an expression for each row it receives from its child operator
and returns that expression to its parent operator.
The VALUES operator has one child operator. 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)The tuple produced by this operatortuple_expr
52 Query Plan Operators