Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to write this sql?

Re: how to write this sql?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 20 Jul 2004 11:28:06 -0700 (PDT)
Message-ID: <20040720182806.83534.qmail@web60709.mail.yahoo.com>


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.....


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US