Robin Sasson (9/17/2012)
Its also depends on whether the columns you are joining on are indexed.Indexing and performance is a large topic in it's own right.
Too many indexes on a large table may slow down INSERT, UPDATE and DELETE whilst giving improvement to SELECT.
Where possible, I prefer JOINS from a readability point of view.
But in many places I have observed that IN beats INNER JOIN in performance.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂