Re: {SPAM} RULE and partitions

Thanks Stéphane, David, Paul, Ghassan

This was what I assumed, but I thought I would see if I was overlooking anything.

Dennis Williams

On 5/3/06, Stephane Faroult <sfaroult_at_roughsea.com> wrote:
>
> Dennis,
>
> With partitions Oracle switches to CBO whatever OPTIMIZER_MODE
> says (a good symptom of that is the appearance of cost estimates in
> execution plans). Therefore, the best you can do is to compute stats.
> They will be ignored (because of OPTIMIZER_MODE) in most cases, and will
> be handy in the other cases.
>
> HTH
>
> Stéphane Faroult
>
> Dennis Williams wrote:
>
> > List,
> > Does anyone have any experience running OPTIMIZER_MODE=RULE, with
> > some tables partitioned in Oracle9i?
> > I have an application on Oracle 8.1.7.4 <http://8.1.7.4>. The
> > vendor specifies OPTIMIZER_MODE=RULE. The vendor supports Oracle9i
> > with this version of the application. I have a lot of data stored in
> > this application. I would like to upgrade the database to 9i so I
> > could partition some of the large tables for manageability. I realize
> > that the RBO is not aware of partitions. This is an OLTP application
> > that uses indexes for all data accesses, so I wouldn't expect any
> > differences. Eventually the application will be upgraded to a version
> > that supports CBO, but that will take a couple of years to roll out.
> > Just looking at what I can do in the meanwhile.
> >
> > Dennis Williams
>
>
>
>

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