Hash Match Join Internals in SQL Server

Описание

Hash Match Joins can join almost any data thrown at them. In this video learn about how the hash match join algorithm works and what seeing hash match joins in your execution plans means for performance of your queries.

Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/DataWithBert?sub_confirmation=1

Related blog post about Hash Match Joins:
https://bertwagner.com/2019/01/02/visualizing-hash-match-join-internals-and-understanding-their-implications/

Be sure to check out part 1 on nested loops joins: https://youtu.be/0arjvMJihJo

And part 2 on merge joins: https://youtu.be/IFUB8iw46RI

Going further in-depth with hash match joins:
https://sqlserverfast.com/epr/hash-match/

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