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

Home -> Community -> Usenet -> c.d.o.server -> SQL performance question

SQL performance question

From: Aakash Bordia <a_bordia_removethis_at_hotmail.com>
Date: Thu, 23 Sep 2004 18:33:08 GMT
Message-ID: <EFE4d.18746$QJ3.14765@newssvr21.news.prodigy.com>


Hi, which SQL query would perform better,(if there is any performance/rewrite/compilation difference internally in Oracle at all):

select * from t1 left outer join t2 on t1.c1=t2.c1,t3

versus

select * from (select * from t1 left outer join t2 on t1.c1=t2.c1) as t4(c1,c2,c3,c4), t3

Thanks

Aakash Received on Thu Sep 23 2004 - 13:33:08 CDT

Original text of this message

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