Does SQL table join order matter?

Have you ever wondered if the order of the tables in your FROM clause matter?

In today's video, we look at why theoretically table join order *does* make a difference for performance and why SQL Server doesn't use the order you provide.

We also look at different techniques for forcing SQL Server to use the join order you specified.

Blog post with all demo code and links:
https://bertwagner.com/2017/11/21/does-the-join-order-of-my-tables-matter/

Presentation by Adam Machanic on row goals:
https://sqlbits.com/Sessions/Event14/Query_Tuning_Mastery_Clash_of_the_Row_Goals

Music by Joakim Karud http://youtube.com/joakimkarud

Follow me on Twitter:
https://twitter.com/bertwagner

Want to receive my latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/

Видео Does SQL table join order matter? канала Bert Wagner