Re: how to write this sql?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 20 Jul 2004 21:11:18 +0100
Message-ID: <7765c89704072013117807768c@mail.gmail.com>

On Tue, 20 Jul 2004 11:28:06 -0700 (PDT), Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> If I recall correctly, which may or may not be true, in 8i inline views
> gave better performance than correlated subqueries

sometimes...

>... so people started

> writing inline views.
>
> then in 9i, the reverse was true but old habits die hard.....

I thought 8i was *new* habits. 6 is old habits and <5 is Mogens archaeolgy territory?

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
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 - 15:08:03 CDT