Does SQL table join order matter?
Автор: Bert Wagner
Загружено: 2017-11-21
Просмотров: 16719
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/doe...
Presentation by Adam Machanic on row goals:
https://sqlbits.com/Sessions/Event14/...
Music by Joakim Karud / joakimkarud
Follow me on Twitter:
/ bertwagner
Want to receive my latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
