RE: Parallel hint ignored only in subquery

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!') );

Without the simple "SELECT * FROM (" wrapper, the PARALLEL hint works fine. I've tried adding an UNNEST hint in the inner and outer SELECTs as well as various PARALLEL hints to no avail.

Thoughts anyone?
Rich

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 24 2008 - 14:32:03 CDT