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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Is SQL procedural or non-procedural?

Re: Is SQL procedural or non-procedural?

From: Paul <paul_at_see.my.sig.com>
Date: Tue, 13 Jun 2006 20:32:55 +0100
Message-ID: <hc4u82ta9201vlt0g05gh27tq6qe02c2t9@4ax.com>

"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.

I'm talking about the Oracle one. Rdb/VMS - isn't that related to Interbase precursors?  

> 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?

Your quote

"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.

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

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 - 14:32:55 CDT

Original text of this message

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