Hash match | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Hash match

Hi all<br />In my query execution plan i find [b[<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />]]Hash Match </b> <br />Iam Unable to understand when this exists<br />It improves performance or it decrease performanc<br /><br />Thanks in advance<br /><br />Malathi Rao
http://www.sql-server-performance.com/jc_parallel_execution_plans.asp &http://msdn2.microsoft.com/en-us/library//aa237090(SQL.80).aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>