Re: Using an index.

From: koert54 <nospam_at_nospam.com>
Date: Sat, 26 Apr 2003 09:34:13 GMT
Message-ID: <posqa.62849$t_2.5508@afrodite.telenet-ops.be>

> Don't rule-out the rule-based optimizer! It rocks!

ignorance is a bless ...
i want to see a warehouse run purely on RBO - without hash-joins and partition pruning - that should be fun !

"Geomancer" <pharfromhome_at_hotmail.com> wrote in message news:cf90fb89.0304251443.4f46b72f_at_posting.google.com...
> >
> > If you're going to IOUG-A I'll try to find time
> > to explain what I did in my presentation on
> > CBO on Monday afternoon.
>
> Um, what you did was make the query run sub-optimally.
>
> Is configuring Oracle to make SQL run slower the topic of your IOUG
> presentation? (Heck, I do that all the time)
>
> Kidding aside, it's no great trick to make the CBO goof up, right?
> Most DBAs spend most of their time getting the CBO going, do a
> benchmark, and then set optimizer_goal=rule.
>
> Don't rule-out the rule-based optimizer! It rocks!
Received on Sat Apr 26 2003 - 04:34:13 CDT