Re: CHOOSE & RULE

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 6 Jun 2002 18:45:18 +1000
Message-ID: <apFL8.6193$Hj3.20200@newsfeeds.bigpond.com>

The question lacks specific details (such as the SQL in question, database version, etc.) so unfortunately so will this answer.

Basically, without the hint, the statement is using the cost based optimizer and its execution plan is obviously not as desirable as the execution plan derived by the rule based optimizer. Reasons for this are too numerous to mention...

You need to "explain" the statements (let me know if you don't know how to do this) and compare the two execution plans. The answer will then be set out before you.

Swap more information for more information if required.

Richard
"Oraclion" <oracle_at_epicentre.fr> wrote in message news:adn50p$ac7$1_at_wanadoo.fr...
> Hi
>
> Note: Optimiser is set to CHOOSE
>
> My request is very speed with a RULE hint in the request but if i dont't
use
> the hint it's very very slowly !!!
> Why ?
>
> Thanks
> Oraclion
>
>
Received on Thu Jun 06 2002 - 03:45:18 CDT