Howto disable subquery factoring at session / instance level

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Wed, 25 Apr 2007 17:02:15 +0200
Message-ID: <486b2b610704250802y7c8b8cbl6e7e071faebb4200@mail.gmail.com>

Hello all,

Is there a way (parameter, event) to set that will prevent the optmizer from materializing subqueries in a WITH clause ? A hint won't help me, because the query is issued by apex itself, and I can't touch that SQL.

Stefan

-- 


=========================


Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com



=========================


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

Received on Wed Apr 25 2007 - 10:02:15 CDT