Re: Is SQL procedural or non-procedural?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Wed, 14 Jun 2006 18:51:52 GMT
Message-ID: <cVYjg.394$Zk3.11230@ursa-nb00s0.nbnet.nb.ca>

David Cressey wrote:

> "Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
> news:lNTjg.322$Zk3.8867_at_ursa-nb00s0.nbnet.nb.ca...
>

>>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 - 13:51:52 CDT