RE: Parallel hint ignored only in subquery

No

A subquery can be unnested into a inline view and then maybe merged into the main query.

But a subquery is not a inline view. inline view is in the from clause.

Subquery is used in the where clause.

A scalar subquery can replace any expression anywhere in the sql statement

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 3:45 PM
To: oracle-l_at_freelists.org
Subject: RE: Parallel hint ignored only in subquery

Relationally speaking, I thought that an inline view was just one type of subquery, no?

--


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


--
http://www.freelists.org/webpage/oracle-l