SQL performance question

#1

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

#2

"Aakash Bordia" <a_bordia_removethis (AT) hotmail (DOT) com> wrote

Quote:

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?

#3

TKPROF is the better to findout this.
Either use this or post the out to find out

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL performance question

comp.database.oracle comp.database.oracle

SQL performance question - 09-23-2004 , 01:33 PM

Re: SQL performance question - 09-24-2004 , 08:51 AM

Re: SQL performance question - 09-27-2004 , 12:06 AM