Re: Is SQL procedural or non-procedural?
Date: Tue, 13 Jun 2006 20:32:55 +0100
"David Cressey" <dcressey_at_verizon.net> wrote:
> I'm familiar with the optimizer that was built into DEC Rdb/VMS. It had
> the effect that I described in my earlier post.
> 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?
"and the "programmers could focus on what data they wanted, instead of how to access it."
With the CBO, you can't do that - there are loads of parameters to fiddle with. That's what it tries to teach - how to best tune those parametres for your system.
As for RBO vs. CBO, there were "tricks" that you could use with the RBO which no longer work with the CBO - hence the learning curve.
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 220.127.116.11.0 (Enterprise Ed.) Interbase 18.104.22.168; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, as a courtesy to those who spend time analysing and attempting to help, please do not top post.Received on Tue Jun 13 2006 - 21:32:55 CEST