SQL Server Performance

Diff between Merge Join(Concatenation) and Merge Join (UNION)..

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Avnish, Apr 2, 2008.

  1. Avnish New Member

    Hi ,
    I have two queries having same output but differ in n the execution plan
    one using : Merge Join(Concatenation)
    second : Merge Join (UNION)
    Which Query is better ?
    Thanks!!
  2. Luis Martin Moderator

    Check:
    http://www.mssqltips.com/tip.asp?tip=1387

Share This Page