I have 2 tables (table1 table2), table2 is larger than table1.
Script 1:
SELECT t1.A, t2.B
FROM table1 AS t1
JOIN table2 AS t2 ON t1.PK = t2.FK
Script 2:
SELECT t1.A, t2.B
FROM table2 AS t2
JOIN table1 AS t1 ON t1.PK = t2.FK
Does performance script #1 will be better than script #2?