Home Forums SQL Server 2005 T-SQL (SS2K5) update command RE: update command

  • November 7, 2009 at 1:45 am

    #1076271

    I prefer the EXISTS. The plan seems more efficient, and the construct more natural.

    TOP (1) would also work in place of the DISTINCT, but I'd still prefer the semi join.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi