Re: {SPAM} RULE and partitions

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