Re: RBO to CBO

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 31 Dec 2004 23:46:54 -0800
Message-ID: <41d65451$1_2@127.0.0.1>

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)

Received on Sat Jan 01 2005 - 01:46:54 CST