If you set optimizer_mode to rule, it will be rule
independent of stats unless sql's explicitly do
something to invoke the cbo (eg with a hint etc).
Your greatest risk would be any SQL's that have a
CHOOSE hint in them. But its worth the risk - rule
based is a dead end street.
hth
connor
- Shaw John-P55297 <P55297_at_motorola.com> wrote: >
8.1.6 on NT
> The product that I support is still Rule based. I am
> planning to bring it
> over to Cost based in the near future. What I wanted
> to do was to set the
> init parameter to 'RULE' and then run statistics on
> the database. My boss
> says we can't do this because "the execution plan
> was different for the "set
> to rule and have statistics" vs. "set to choose and
> no statistics".
> I haven't heard this before - can anybody point me
> to the Fine Manual to
> confirm or refute this. Perhaps this is another of
> those fine urban legends?
> For the time being I am starting out with a small
> test database.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Shaw John-P55297
> INET: P55297_at_motorola.com
>
> 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: ListGuru_at_fatcity.com (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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Mon Apr 22 2002 - 10:03:19 CDT