Hope you guys are getting ready for Diwali Festival :-). Before you guys start with the festival event I thought of writing an article on performance. Couple of days ago one of the developer came to me and said he was using an INNER join in his query and he is getting delay in results, soon after he changes it to LEFT OUTER join he could see some improvement in getting the results. I was blinking for a second and I started arguing with him that this will change the business logic & asked him to explain me how’s OUTER join faster so we went into an argument which resulted in this article.
SQL Server joins are required to retrieve data from one or more tables to get a single result set. Joins are needed when Normalization enforced in design. When you normalize the data you be reducing redundancy in data by placing data in different tables and also you will be creating relationship between the tables. With the help of these relationship you will be retrieving the data using joins efficiently.