Re: RULE and partitions

On 5/3/06, Dennis Williams <oracledba.williams_at_gmail.com> 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. 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
>

C'mon Dennis. Live a little. Upgrade straight to 10.2.0.1 and apply 10.2.0.2 .
You know that you want to.
Then have a look at optimizer-mode='FIRST_ROWS_10'.

refer to Appendix A - Upgrade Headaches of Jonathan Lewis' Cost-Based Oracle Fundementals

hth.

Paul

--
http://www.freelists.org/webpage/oracle-l