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@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