Performance Tunning

Performance View on INNER JOIN and OUTER JOIN

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.