Re: RULE vs CHOOSE

Business Information Services wrote:

> Hi,
>
> Probably another stupid question ... :-)
>
> If the database tables are never analysed is there any point in having
>
> the OPTIMISER set to CHOOSE (the default) and in fact would it slow
> things down? I mean I don't know what happens in the bowels of Oracle
> but
> I'd say it would probably spend some superfluous time searching for
> table
> statistics before using rules.
>
> Any thoughts appreciated.
>
> Rowan McCammon.

  If your tables are not analysed then CHOOSE is simply equivalent to RULE.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen_at_ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.