Neoview Query Guide (R2.2)

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
UNPACK Operator
Use the UNPACK operator in a query plan when an array is used as input in a query (for example,
inserting rows from rowset arrays). The UNPACK operator extracts the elements from the array
to use in the query.
The UNPACK 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
expr(text)Expression used to extract values from a packed rowunpack_expression
integerSystem-generated index used when accessing a packed rowindex_value
expr(text)The number of logical rows in the packed rowpacking_factor
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
Understanding Joins 63