RE: Parallel hint ignored only in subquery

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Rich Jesse
> Sent: Thursday, July 24, 2008 12:36 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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-l

Other related posts: