Performance tuning

Database
Enthusiast

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?

2 REPLIES
Enthusiast

Re: Performance tuning

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

Enthusiast

Re: Performance tuning

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