1 year ago
#335366
user17611369
Does the order of the tables in the INNER JOINs and the FROM clause matter?
So assume you perform an inner join between table1 and table2 on column1 Does it make a difference if the table with lower entries is in the FROM-clause?
So you start with less results in the first place and then the Join will reduce it less than the other way around.
Same thing for multiple INNER JOINs, should you put the JOINs first that will reduce the results the most, so the following joins have less work? Or does it not follow an procesing order?
sql-server
processing-efficiency
0 Answers
Your Answer