Re: Cost Based Optimizer Question

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/05/23
Message-ID: <5AEW4.1678$Ad6.23368@typhoon.southeast.rr.com>#1/1

You can always use RULE hint to force rule-based optimization.

"ttrivedi" <ttrivedi_at_deja.com> wrote in message news:392AFD95.67763049_at_deja.com...
>
>
> Hey gurus,
> I have a quick question . Is it true that if the statistics for even a
> SINGLE table is available
> then the cost based optimizer WILL be used irrespective of what is
> specified ?
>
> Like if I do
> analyze table one compute statistics
> then I cannot use the rule based optimizer any more ?
>
>
> Tapan
>
Received on Tue May 23 2000 - 00:00:00 CDT