Performance Tuning has been my favorite subject and I have done it for many years now. Today I will list one of the most common conversations about Index I have heard in my life. Let us see a funny cartoon on the Index and Performance Tuning.
Every single time, I am at consultation for performance tuning I hear following conversation among various team members. I want to ask you, does this kind of conversation happen in your organization?
Anyway, If you think the Index solves all of your performance problems I think it is not true. There are many other reasons one has to consider along with Indexes. For example, I consider following various topics one need to understand for performance tuning.
Well, I have written this blog thinking I will keep this blog post a bit easier and not load up. I will in the future discuss about other performance tuning concepts. Let me know what do you think about the cartoon I made.
Reference: Pinal Dave (http://blog.sqlauthority.com)