Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

NoteNote

This operator only applies to SQL Server 2000 before SP1.

Hash match root operator iconGraphical execution plan icon

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.