Re: rm RULE based optimizer != GOOD IDEA

On 4/21/05, Post, Ethan <Ethan.Post_at_ps.net> wrote:
> The problem with that is the environment for the most part is very
> stable and things run very nice, why go about making changes that are
> going to effect every query on the system to tweak one query? And again,
> the argument is why spend time trying to figure this out, no matter how
> wonderful the CBO becomes, it will occasionally screw up, and if all I
> need to do is add +RULE and walla! then I think that feature better stay
> (at the statement level for the very least). Just an argument to keep
> RULE around, I can't recall what Oracle says the status of this is.

It seems a big leap to me from "adding the RULE hint helps my one query", to "we should keep the RBO", not least because you can achieve the same effect without the RULE hint.

--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l