Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer

Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Rate this post

Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application began running slow and I had to find out the reason of the slowdown, I was amazed to find these queries. Here is what SQL Server sometimes has to deal with: Read More