If I recall correctly, which may or may not be true, in 8i inline views
gave better performance than correlated subqueries... so people started
writing inline views.
then in 9i, the reverse was true but old habits die hard.....
- Jared.Still_at_radisys.com wrote:
> > I don't understand the tendency to write everything inline.
> >
> ...
> >
> > What is the fun of creating horrible, unintelligible SQL statements
>
> > intended to
> > do this little thing?
> >
>
> I suspect it is tied to the performance hit encountered when using
> stored functions in a SQL statement in older (v7) versions of Oracle.
>
> Using a stored function in SQL then was a huge performance hit.
>
> As of 8i (IIRC) that was no longer true.
>
> Hard learned lessons die just as hard.
>
> Jared
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 13:24:49 CDT