Blog Post

SQL Server Blog
6 MIN READ

Hash Join

Craig_Freedman's avatar
Craig_Freedman
Icon for Microsoft rankMicrosoft
Mar 23, 2019
First published on MSDN on Aug 10, 2006 When it comes to physical join operators, hash join does the heavy lifting.  While nested loops join works well with relatively smal...
Updated Mar 23, 2019
Version 2.0
sqlserverqueryprocessing
junli1026's avatar
junli1026
Copper Contributor
Jun 22, 2023

Thank you Craig_Freedman for the education, this is very helpful!

Do you mind share a little more about bushy join ? Seems it is expensive for (CBO) cost-based optimizer to search and find a good bushy tree, but is there any other consideration about bushy tree ? Like the pros and cons of a bushy tree? 

 

Thank you!