Re: {SPAM} RULE and partitions
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: "Stephane Faroult" <sfaroult@xxxxxxxxxxxx>
- Date: Thu, 4 May 2006 08:15:24 -0500
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@xxxxxxxxxxxx> 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
Other related posts:
