SQL Server Performance

Hash match

Discussion in 'Getting Started' started by jogin malathi, Jun 27, 2007.

  1. jogin malathi New Member

    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
  2. satya Moderator

    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.

Share This Page