Re: Is SQL procedural or non-procedural?
Date: Tue, 13 Jun 2006 11:46:03 GMT
Message-ID: <%zxjg.3573$n93.2910_at_trndny07>
"Paul" <paul_at_see.my.sig.com> wrote in message
news:g2hr82dcti546301pl4d0qkk4ufhke50ep_at_4ax.com...
>
>
> "David Cressey" <dcressey_at_verizon.net> wrote:
>
>
>
> > By contrast, some other products had cost based optimization, and the
> > programmers could focus on what data they wanted, instead of how to
access
> > it.
>
>
> I'd suggest that you take a look at Jonathan Lewis' book "CBO, the
> fundamentals" to see how wrong you are there.
>
>
> Sure, the CBO is *_meant_* not to worry, but boy, it does!
>
People who are familiar with DB2 assure me that the DB2 optimizer was also
very good.
I've seen Oracle shops converting from RBO to CBO, and they need to go
through a cultural shift.
What does "CBO, the fundamentals" teach?