Re: RBO to CBO

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

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB