Re: RULE vs CHOOSE
From: Vitaly Sikolenko <vsikolen_at_ru.oracle.com>
Date: 1997/08/11
Message-ID: <33EEC3B6.AB4EC967_at_ru.oracle.com>#1/1
Date: 1997/08/11
Message-ID: <33EEC3B6.AB4EC967_at_ru.oracle.com>#1/1
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.Received on Mon Aug 11 1997 - 00:00:00 CEST