This is a discussion on Parallel SELECT for UNIONs within the Oracle Database forums, part of the Database Server Software category; --> Oracle 8.1.7.4 on HP-UX 11. Sample query: SELECT /*+ FULL(x) PARALLEL(x,5) */ count(*) from foo1 x UNION ALL SELECT ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Oracle 8.1.7.4 on HP-UX 11. Sample query: SELECT /*+ FULL(x) PARALLEL(x,5) */ count(*) from foo1 x UNION ALL SELECT /*+ FULL(x) PARALLEL(x,5) */ count(*) from foo2 x What I would like is both the SELECTs running in parallel, and each using in turn 5 PQs. What I see is the SELECTs running in serial (i.e. SELECT on foo1 and then the SELECT on foo2, each using 5 PQs when it runs). Is there a way to have both SELECTs running in parallel when using a UNION? -- Billy |