SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-46
MultiUnion Operator
prepare xx from
select * from table_a
union
select * from table_c;
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
union_type .............. merge
MultiUnion Operator
N-ary Group
The MultiUnion operator provides performance enhancement for queries that have a
large number of table unions. It denotes a single relational union operator with multiple
children. Its children can be any relational operators that are attached to the union
backbone.
The description field for this operator contains:
The following is an example of the MultiUnion operator:
create table tabl3 (a int, b int, c int,d int, e int);
prepare xx from select * from tabl3 union all
select * from tabl3 union all
select * from tabl3 union all
select * from tabl3 union all
select * from tabl3;
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
union_type ............. PhyMultiUnion
NESTED_ANTI_SEMI_JOIN Operator
Join Group
The NESTED_ANTI_SEMI_JOIN operator describes a portion of an execution plan
that involves a nested join. This operator returns all rows from the inner table that do
not satisfy the predicates. See NESTED_JOIN Operator on page 7-47.
Note. The MultiUnion operator is supported only on systems running J06.08 and later J-series
RVUs and H06.19 and later H-series RVUs.
Token Followed by ... Data Type
union_type PhyMultiUnion text
TP663851.fm Page 46 Monday, October 17, 2011 11:48 AM