Re: RBO to CBO

DA Morgan 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.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)

maybe they are just futuristic thinkers who know that the cursor loop processing (if they've coded appropriately) will auto-bulk for them in 10g ?

then again....maybe they're not

:-)

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------