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?


The SQL Server Query Optimizer doesn’t care, so it comes down to your preference.

For legibility, I prefer the first option, where the table order is reflected in the predicate order.

Some people like having the order reversed.

Which do you prefer, and why?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: