Re: Optimizer

From: Jeff Hunter <marist89_at_excite.com>
Date: 2000/05/14
Message-ID: <391f5eec@defiant.btitelecom.net>#1/1

I thought I read somewhere that Rule-based optimization will be going away in future versions... When using cost based optimization, your objects need to be optimized on a regular basis.

RL <mark_at_mark-it.demon.co.uk> wrote in message news:958301705.11737.0.nnrp-14.9e9864e7_at_news.demon.co.uk...
> I appreciate this is probably a huge topic, but can anyone point
> me in the direction of information about the Oracle optimizer.
> In particular, what should the optimizer rule be
> set to (CHOOSE, RULE etc). If the optimizer is using cost
> based optimization, is it necessary to analyze tables regularly or
> can it be run once. Does the cost based optimizer always give better
> results that the rule based optimizer or are there too many variables
> to decide this.
>
> Are there are good tools to help with optimization, (where to add
> indexes etc), I found tkprof output very cryptic.
>
> Many thanks
>
>
>
Received on Sun May 14 2000 - 00:00:00 CDT