Does "Join" order will lead to different query performance

Viewed 189

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?

3 Answers
Related