All Forums Database
barani_sachin 141 posts Joined 01/12
14 Mar 2013
Performance tuning

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?

14 Mar 2013

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 137 posts Joined 12/12
15 Mar 2013

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

You must sign in to leave a comment.