1 year ago

#335366

test-img

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

Accepted video resources