Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Howto disable subquery factoring at session / instance level

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US