Unix Technical Forum

Parallel SELECT for UNIONs

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 ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-22-2008, 05:17 PM
Billy Verreynne
 
Posts: n/a
Default Parallel SELECT for UNIONs

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com