RE: Parallel hint ignored only in subquery
- From: "Poddar, Amit" <amit.poddar@xxxxxxxx>
- To: "rjoralist@xxxxxxxxxxxxxxxxxxxxx" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Jul 2008 19:56:17 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich Jesse
Sent: Thursday, July 24, 2008 3:45 PM
To: oracle-l@xxxxxxxxxxxxx
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@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]
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
