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-14
ESP_EXCHANGE Operator
create view view30 as
select * from tabl3 union all
select * from tabl3 union all
select * from tabl3 union all
select * from tabl3 union all
select * from tabl3;
create view view40 as
select * from tabl4 union all
select * from tabl4 union all
select * from tabl4 union all
select * from tabl4 union all
select * from tabl4;
insert into tabl3 values
(1,2,3,1,1),(4,5,6,1,1),(7,8,9,1,1),(1,2,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,5,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(1,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(1,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(9,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(1,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(1,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(1,2,3,1,1),(4,4,6,1,1),(7,7,9,1,1),(1,9,3,1,1),(4,5,6,1,1),
(7,8,9,1,1),
(4,5,6,1,1),(7,8,9,1,1);
insert into tabl4 select * from tabl3;
insert into tabl3 select * from tabl4;
?section test
CONTROL QUERY DEFAULT CHECK_CONSTRAINT_PRUNING 'ON';
CONTROL QUERY DEFAULT INTERACTIVE_ACCESS 'ON';
CONTROL QUERY DEFAULT UNION_TRANSITIVE_PREDICATES 'ON';
CONTROL QUERY DEFAULT COMP_BOOL_25 'ON';
CONTROL QUERY DEFAULT MERGE_JOINS 'OFF';
CONTROL QUERY DEFAULT HASH_JOINS 'OFF';
CONTROL QUERY DEFAULT OPTIMIZER_PRUNING 'OFF';
TP663851.fm Page 14 Monday, October 17, 2011 11:48 AM