Re: Oracle 11g new features

From: Matthias Hoys <anti_at_spam.com>
Date: Tue, 27 Mar 2007 22:11:38 +0200
Message-ID: <46097a79$0$14248$ba620e4c@news.skynet.be>

<sybrandb_at_hccnet.nl> wrote in message
news:ndmi03p5ifsnms3868jka1f9gd3gdkgbp6_at_4ax.com...
> On Mon, 26 Mar 2007 19:43:00 +0200, "Matthias Hoys" <anti_at_spam.com>
> wrote:
>
>>NOOOOOOOO !!! Don't take the RBO away please !!!!! Aaaaaarrgrggghhhhh ....
>>
>>/*+ RULE */ hints forever :-)
>>
>
> Sucker! The CBO outperforms RBO on all counts. Why stay in the
> Flintstone age?
> Because you don't want to learn CBO. If I were your employer I would
> lock you up to make you follow a CBO course!
>
> --
>
> Sybrand Bakker
> Senior Oracle DBA

Of course, I was just joking, Sybrand :-) I do understand the advantages of the CBO, but tell that to third-party software vendors with embedded /*+ RULE */ hints all over the place. For 11g, I would like to have an advanced version of the DBMS_ADVANCED_REWRITE package with flexible query replacements options. For example : replace all queries that start with SELECT /*+ RULE */ * FROM ... by SELECT * FROM ... :-)

Matthias Received on Tue Mar 27 2007 - 15:11:38 CDT