SQL Server Performance

Left join vs Right Join - Performance

Discussion in 'T-SQL Performance Tuning for Developers' started by jetlim, Jan 14, 2004.

  1. jetlim New Member

    Hi There,
    Are there significant performance difference between
    left join and right join? If yes, which one is more
    efficient?


    Thanks,
    Charles
  2. satya Moderator

  3. Negative New Member

    Pay special attention to the part of the article satya mentioned were it talks about if you really need a left join. In reality, the decision of which join to use should be based on the requirements of the query first, and then if performance is in need of improvement, you can look to other measures to speed it up. I would highly recommend looking in BOL to make sure you really understand the difference between join types, as they all function differently.

Share This Page