Hash Match Root Showplan Operator

The Hash Match Root operator coordinates the operation of all Hash Match Team operators directly below it. The Hash Match Root operator and all Hash Match Team operators directly below it share a common hash function and partitioning strategy. The Hash Match Root operator always returns output to an operator that is not a member of its team.

Note

The Hash Match Root operator was removed from the query optimizer to improve performance in SQL Server 2000 SP1 and later. This operator only applies to SQL Server 2000 before SP1.

Graphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Hash Match Team Showplan Operator

Concepts

Logical and Physical Operators Reference
Understanding Hash Joins
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance