Re: SQL performance question

From: Alan <alan_at_erols.com>
Date: Fri, 24 Sep 2004 09:51:31 -0400
Message-ID: <2rin30F1ac1hnU1@uni-berlin.de>

"Aakash Bordia" <a_bordia_removethis_at_hotmail.com> wrote in message news:EFE4d.18746$QJ3.14765_at_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
>
>

Why don't you try it and see? Received on Fri Sep 24 2004 - 08:51:31 CDT