Performance tuning

[barani_sachin]

Hi All,

I have two tables lets say Tab1 with 1million records and Tab2 with 100million records.

Option 1) sel columns from tab1 inner join tab2

Option 2) sel columns from tab2 inner join tab1

Is option one better than option two? does it make a difference?

[Nishant_Bhardwa]

Hi ,

Just check the  Explain plan of both the Queries.. Will get to know the differences..check the timings and final spool size in the Explain..  I think both would be same as its a inner Join... but its good to check..

thanks!

Nishant Bhardwaj

[KS42982]

No it doesn't make a difference how you do INNER JOIN, it would be same.