Re: Cost Based Optimizer Question

From: Mike Hately <mike.hately_at_virgin.net>
Date: 2000/05/24
Message-ID: <8gf5d7$rub$1@lure.pipex.net>#1/1

Tapan

Unless you have optimizer_mode=rule for your session then the CBO will be used if there are statistics for any of the tables involved in the current join.

Regards

Mike Hately

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 Wed May 24 2000 - 00:00:00 CDT