Parallel SELECT for UNIONs

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Mon, 23 Dec 2002 08:00:30 +0200
Message-ID: <au68ue$7rn$1@ctb-nnrp2.saix.net>

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

Received on Mon Dec 23 2002 - 00:00:30 CST