Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL performance question
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