Re: cost based optimizer vs rule based optimizer

From personal experience, cost based blows away the rules based optimizer. Cost based is a much more intelligent optimizer. Remember to analyze your tables and indexes so that the optimizer actually has statistics to work with, otherwise it is pointless....

Cheers,

Robert Prendin

Kel Bahi <kbahi_at_creo.com> 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