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

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

RE: Plan stability with rule based optimzier

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 11 Feb 2005 15:57:39 +0100
Message-Id: <20050211145745.A1FD24A1E03@ha-smtp3.tiscali.nl>


sorry -- I was trying to say two things at the same time. The CHOOSE hint only kicks in CBO if statistics are available, because otherwise it would default back to RULE, making the hint useless. Therefore I assumed the presence of object statistics. So if the intent is to deviate from RULE behavior for a specific SQL statement,
using ALL_ROWS or FIRST_ROWS(n) is the preferred method.

Lex.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lex de Haan
Sent: Friday, February 11, 2005 15:52
To: JBECKSTROM_at_gcrta.org; oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com Subject: RE: Plan stability with rule based optimzier

of course you can do that -- the hint will unconditionally kick in the CBO. I think it is better to throw in an ALL_ROWS or FIRST_ROWS(n) hint, by the way.
Lex.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Friday, February 11, 2005 15:09
To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com Subject: Plan stability with rule based optimzier

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 11 2005 - 10:00:33 CST

Original text of this message

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