Can an Index reduce the performance of SELECT Queries?
Let me make this question a bit more complete –
Can an Index reduce the performance of SELECT Queries even though that index is not used anywhere?
If your answer is NO, well, continue reading.
Whenever I say that Indexes reduces the performance of your Insert, Update and Delete, I have always got happy nodes about the same. However, as soon as I mentioned that the same index can be dangerous for your SELECT statement, I always see a surprised look on their face.
Finally, I have decided to create a video on the same subject. Please go ahead and watch the video where I demonstrate an index even though not used for a query can reduce the performance of the SELECT statement.
Top 5 Follow Questions on SELECT Queries
Here are the top 5 questions I have received from everyone who has watched my demonstration in detail:
- Why an index is reducing the performance of the SELECT statement?
- How to create an optimal index which is best for your workload?
- How to rank various indexes in terms of their impact on queries?
- What should you do to maintain optimal performance for your server?
- What are the other such pitfalls?
After receiving many such questions, I have decided to create an in-depth course, which answers not only the above questions but also teaches my business secrets of SQL Server Performance Tuning. If you believe indexes are the performance tuning secret weapon, you will realize in my course that there are many more things to consider over indexes when it is about SQL Server Performance Tuning.
Build Your Methodology
I personally believe that if you want to become a good SQL Server Performance Tuning consultant, you can just follow my footsteps in the beginning and help your customers with their server’s performance. Once you are comfortable with my methodology, you can develop your system on the top my way of tuning system and build your own SQL Server Performance Tuning Methodology.
Call to Action
If you have missed attending my SQL Server Performance Tuning Practical Workshop for EVERYONE, you still have a chance to watch the recorded class. Here is the link to read more about the class and link to register. Remember, if you register before June 2nd, 2019. You also qualify for Buy One Get One deal where you also get 1 free hour SQL Server Performance Tuning Consultation.
Please note that the buy one and get one offer is only available for the next 7 days.
Reference: Pinal Dave (https://blog.sqlauthority.com)