Why the result we get is the result we get. The answer is very simple – it is because of the Logical Processing Order of the SELECT Statement.
Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.