Re: Is SQL procedural or non-procedural?

From: Bob Badour <>
Date: Wed, 14 Jun 2006 18:51:52 GMT
Message-ID: <cVYjg.394$>

David Cressey wrote:

> "Bob Badour" <> wrote in message
> news:lNTjg.322$

>>David Cressey wrote:

>>Your comment about "how wrong I was" applies to the Oracle CBO, and not
>>>necessarily to the CBO's of other products.
>>>We've been talking past each other.
>>Keep in mind that Paul is part of the Oracle borg. No other dbmses exist
>>in his universe.

> In that case, he should be aware that Oracle Corp. bought the rights to DEC
> Rdb/VMS from DEC in October of 1994.
> And, I am told by people who ought to know, that the DEC Rdb/VMS optimizer
> had a strong infuence on the design of the first version of the CBO for
> Oracle RDBMS. The fact that Oracle programmers are still busy trying to
> outfox the optimizer says more about Oracle culture than about anything
> else.

In defence of the fox-outers, Oracle's CBO has some downright bugs from my recollection. Received on Wed Jun 14 2006 - 20:51:52 CEST

Original text of this message