SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-53
TUPLELIST Operator
The example of the TUPLE_FLOW operator is based on:
UPDATE abase SET two = two + 1 WHERE unique3 < 32000;
3 6 7 tuple_flow
join_type: inner
join_method: in-order nested
parallel_join_type: 1
TUPLELIST Operator
Tuple Group
The TUPLELIST operator shows the values that you place in the query when the
VALUES clause is used. The description field for this operator contains:
The example of the TUPLELIST operator is based on:
INSERT INTO $big18a.tpcd2x.nation
VALUES (43, 'botswana', 16, 'african country'),
(44, 'france', 23, 'european country'),
(45, 'nepal', 88, 'asian country');
. . 1 tuplelist
tuple_expr: cast(45), cast('nepal'), cast(88), cast('asian
country'
UNIQUE_DELETE Operator
DAM Unique Group
The UNIQUE_DELETE operator describes a portion of an execution plan that works on
one row only. It deletes zero or one row.
join_predicate Expression of the join
predicates
expr(text)
parallel_join_type Type1 or Type2, depending
on parallel join algorithm
text
selection_predicate Expression of the selection
predicates
expr(text)
Token Followed by... Data type
tuple_expr The tuple produced
by this node
expr(text)
Token Followed by ... Data Type