Re: 'RULE' based optimizer on certain tablespace?

From: Anurag Varma <avdbi_at_nospam.hotmail.com>
Date: Tue, 04 Sep 2001 20:54:34 GMT
Message-ID: <ecbl7.1081$k51.353108@news02.optonline.net>

First thing is you need to ask the application vendor WHY??

Look into stored outlines. Basically you would have to set the database on rule based
and then start saving the stored outlines of this application by running this application (and this application alone). After you are done with it, set system back to CBO. You can even do this on a test database which represents your data pretty nicely,, and then import the stored outlines.

For more info on stored outlines: Look into the Oracle Performance Tuning Documentation available on OTN.

Anurag

"Helen" <hhjin_at_yahoo.com> wrote in message news:ebcac1e2.0109041148.1dfc2269_at_posting.google.com...
> I have a 8.1.6 Oracle DB with optimizer set to be 'choose'.
>
> Our application vendor suggested to set the optimzier
> to be 'rule' based for a certain tablespace.
>
> Any ideas how?
>
> My understanding is that you can change the optimizer on
> instance level, session or statement level (use /*).
>
> Thanks
>
> Helen
Received on Tue Sep 04 2001 - 15:54:34 CDT