Hash Match Team Showplan Operator

The Hash Match Team operator is part of a team of connected hash operators sharing a common hash function and partitioning strategy.

Hash Match Team is a physical operator.


The Hash Match Team 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.

Hash match team operator iconGraphical execution plan icon

See Also


How to: Display an Actual Execution Plan


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