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


Other related posts: