Re: RBO to CBO

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 04 Jan 2005 23:32:24 -0800
Message-ID: <41db96d7$1_1@127.0.0.1>

xhoster_at_gmail.com wrote:

> DA Morgan <damorgan_at_x.washington.edu> wrote:
> 

>>Mladen Gogala wrote:
>>
>>
>>>On Thu, 30 Dec 2004 10:04:44 -0800, DA Morgan wrote:
>>>
>>>
>>>
>>>>Provided you only use table and index types that existed in Oracle 6.
>>>
>>>
>>>There are many people that only use features of Oracle9 that were
>>>available with Oracle 7. Many developers don't know about things
>>>like VARRAY, TABLE & CAST operators to access PL/SQL tables and there
>>>are even DBAs who have learned about query factoring very short time
>>>ago. The category of users implied by your comment is not very small.
>>
>>I think it is unfortunately the vast majority of developers and DBAs.
>>And when it comes to PL/SQL I rarely see anything that couldn't have
>>been written in Oracle 7. Cursor loops everywhere and not even a hint
>>they know what a BULK COLLECT or FORALL is.

> 
> 
> IMHO, stupid is what they are.  I think Oracle could have used the same
> methodologies underlying BULK COLLECT and FORALL to just make the good old
> cursor loop faster, without requiring everyone to rewrite their code so
> that it uses the incredibly verbose and tortured syntax.
> 
> Xho

Can't say I can find any grounds upon which to disagree.

If query rewrite can turn my mediocre SQL into beter performing SQL I would think that it could and should do this too.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Jan 05 2005 - 01:32:24 CST