SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
7-82
TUPLE_FLOW Operator
The TUPLE_FLOW operator has two child nodes. The description field for this operator
contains the following:
The following is an example of the TUPLE_FLOW operator:
prepare TestQuery38 from
UPDATE table_b SET owner_count = (
SELECT count(*) FROM table_a
WHERE (table_b.col1,table_b.col2)=
(table_a.col1,table_a.col2)
AND table_a.col3 = 1
);
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
transpose_union_vector
ValueIdUnion('0', '1', '2', '3',
'4', '5', '6', '7', '8', '9')
Token Followed by ... Data Type
fragment_id A sequential number assigned to the fragment.
0 is always the master executor and 1 is
reserved for the EXPLAIN plan. Numbers 2 to n
will be ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type Master, ESP, or DP2. text
join_type Inner, left, natural, inner semi, or inner anti-
semi-join.
text
join_method Name of join method:nested or in-order nested
join.
text
join_predicate Expression of the join predicate expr(text)
parallel_join_type Type1 or Type2, depending on parallel join
algorithm
text
selection_predicate Expression of the WHERE clause expr(text)
TP663851.fm Page 82 Wednesday, January 30, 2013 5:37 PM