jzhardy
Active User
Joined: 31 Oct 2006 Posts: 131 Location: brisbane
|
|
|
|
I have a set of queries Q1 .. QN which are result set compatible.
eg Q1 might be:
Code: |
select id -- id is dec 9
from some_table where id in (1,2,3); |
Q2 might be:
Code: |
Select id -- id is dec 9
from another_table where id in (5,6,7); |
If I string these together as:
Q1 union all Q2 union all ... Qn
does DB2 guarantee internal parallelism ?
Assume that I have set current degree = 'ANY'
what other considerations are there ? traps for the unwary etc. |
|