Re: cost based optimizer vs rule based optimizer

Default optimizer is COST for Oracle 8, I think... Whatever you do, don't use COST for Oracle Financials! That package is designed to use RULE.

Thats my 2 cents worth

Kel Bahi wrote:

> Hi
> Does anyone have any opinions on which optimizer to use?
> Are they comparable? Is one always better than the other?
> Does it depend on the database ( volume, rate of change)
>
> Any info appreciated.
> BTW we are using oracle 8.0.3 under NT.
>
> Thanks
> Kel Bahi
> Creo Products
> kbahi_at_creo.com
Received on Thu Jun 04 1998 - 00:00:00 CDT