Re: {SPAM} RULE and partitions
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Wed, 03 May 2006 21:46:58 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
