Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Parallelism » Joins   (RSS)
Sorry, but there are no more tags available to filter with.

Parallel Hash Join

SQL Server uses one of two different strategies to parallelize a hash join . The more common strategy uses hash partitioning. In some cases, we use broadcast partitioning; this strategy is often called a “broadcast hash join.” Hash Partitioning The more
Posted by craigfr | 0 Comments
Filed under: ,

Parallel Nested Loops Join

SQL Server parallelizes a nested loops join by distributing the outer rows (i.e., the rows from the first input) randomly among the nested loops threads. For example, if we have two threads running a nested loops join, we send about half of the rows to
Posted by craigfr | 3 Comments
Filed under: ,
 
Page view tracker