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?
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..