RE: Parallel hint ignored only in subquery
Date: Thu, 24 Jul 2008 14:44:39 -0500 (CDT)
Message-ID: <29832.12.17.117.251.1216928679.squirrel@12.17.117.251>
Relationally speaking, I thought that an inline view was just one type of
subquery, no?
I did not try the NO_MERGE until just now and it works! I learned something
new today, or at least I learned that I'll have to learn more about
MERGE/NO_MERGE.
Thanks, Amit!
Rich
> This is not a subquery but an inline view.
>
> Did you try no_merge hint
>
> Amit
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Rich Jesse
> Sent: Thursday, July 24, 2008 12:36 PM
> To: oracle-l_at_freelists.org
> Subject: Parallel hint ignored only in subquery
>
> Hey all,
>
> SELECT * FROM (
> SELECT /*+ parallel (aa 4) */
> aa.col1, bb.col1, cc.col1, cc2.col1...
> FROM aa
> JOIN bb on aa.pk = bb.pk
> LEFT OUTER JOIN cc on cc.pk1 = aa.pk AND cc.pk3 = aa.pk1
> LEFT OUTER JOIN cc CC2 on cc2.pk2 = aa.pk2
> ...
> WHERE bb.stuff IN ('yadda', '?Yadda', 'YADDA!')
[snip]
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 24 2008 - 14:44:39 CDT