Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 11g new features

Re: Oracle 11g new features

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 28 Mar 2007 08:26:56 -0700
Message-ID: <1175095614.792138@bubbleator.drizzle.com>


Matthias Hoys wrote:
> <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

That is why it needs to be killed: Third-party software vendors.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Mar 28 2007 - 10:26:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US