Rachel
I recently heard about something called a Stored Outline that supposedly can
be used to lock the execution path that a query runs with. One of the uses
of this was apparently to aid people moving from rule to cost based
optimisation, where the rule execution path may be the better option to go
down.
Did/have you looked at these as an alternative to the hint? I am curious to
see if anybody has used this option and what feedback they may have?
Cheers
Mark
-----Original Message-----
Carmichael
Sent: Tuesday, April 24, 2001 02:16
To: Multiple recipients of list ORACLE-L
turning on cost-based is easy: set the optimizer_mode parameter to choose
in your init.ora, stop and start your database and then analyze all your
tables.
HOWEVER (and this is a biggie) this will not automatically make all your
queries run faster. You will need to examine each and every query to see if
it needs to be rewritten to take advantage of CBO. In fact, sometimes there
are queries that run faster in rule-based, and I have had to include hints
in queries to force the optimizer to run rule.
>From: Venkat_Kalepalli <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: MTS&Cost based Optimzer
>Date: Tue, 24 Apr 2001 02:25:25 -0800
>
> > Hello folks!
> >
> > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS
> > on the Oracle server. Next we are running with Rule based optimizer and
> > we want to change to costbased optimizer.
> >
> > I want to know what are the advantages we get on this and what are the
> > steps to implement this?
> >
> > Any help is grateful...
> >
> > Rgd
> > Venkat
> > DBA.
> >
> >
> >
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
