Survey: Join Predicate Order
It’s a quiet month as we look forward to 2016, so I’m asking a series of survey questions for the next few posts. My first one is about the order of join predicates. When joining two or more tables in T-SQL, which do you prefer?
1 2 3 4 |
SELECT * FROM TableA a INNER JOIN TableB b ON <strong>a</strong>.Col1 = <strong>b</strong>.Col1 |
or
1 2 3 4 |
SELECT * FROM TableA a INNER JOIN TableB b ON <strong>b</strong>.Col1 = <strong>a</strong>.Col1 |
The SQL Server Query Optimizer doesn’t care, so
-> Continue reading Survey: Join Predicate Order