Left join vs Right Join – Performance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Left join vs Right Join – Performance

Hi There,
Are there significant performance difference between
left join and right join? If yes, which one is more
efficient?
Thanks,
Charles
One of the best ways to boost JOIN performance is to limit how many rows need to be JOINed – as mentioned in thishttp://www.sql-server-performance.com/tuning_joins.asp link. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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.
]]>