Does the order in which the tables are placed inside a join matter for getting better performance?
Assuming, below query what is the best way to re-arrange the join order? what considerations to be taken care?
from t1 inner join t2 on t1.c2 = t2.c4
inner join t3 on t3.c1 = t2.c3 and t3.c3 = t1.c6
inner join t4 on t4.c2 = t3.c1
where t1.iscurrent = 1
and t3.dt between 'date-1' and 'date-2'
t1 = 150 rows
t2 = 9634765 rows
t3 = 9000 rows
t4 = 70 rows