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

Home -> Community -> Mailing Lists -> Oracle-L -> Plan stability with rule based optimzier

Plan stability with rule based optimzier

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 11 Feb 2005 09:09:23 -0500
Message-Id: <s20c7659.058@gcrta.org> 





Before going to far, I want to make sure this will work.
 


Our database is running with RULE set at the database level.  We would
like to tune an SQL statement in a third party application by using a
stored outline.  For the sql in question, we are going to add a "Choose"
database hint.
 


Is it possible to use stored outlines if the database is running in
RULE mode?
 
 
 


Jeffrey Beckstrom


Database Administrator


Greater Cleveland Regional Transit Authority
1240 W. 6th Street


Cleveland, Ohio 44113


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


Received on Fri Feb 11 2005 - 09:12:51 CST












Original text of this message













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