During Comprehensive Database Performance Health Check we often discuss dropping indexes that are not helpful and systematically and scientifically we drop them. However, the biggest challenge I face during the conversation is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index in today’s quick SQL in Sixty Seconds video.
If you are looking for the script used in this video, the link is SQL SERVER – Finding Queries Using Particular Index. Here is the video:
If you liked this blog, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.
Here are my few recent videos and I would like to know what is your feedback about them.
- Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179
- One Scan for 3 Count Sum – SQL in Sixty Seconds #178
- SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
- COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176
- COUNT(*) and Index – SQL in Sixty Seconds #175
- Index Scans – Good or Bad? – SQL in Sixty Seconds #174
- Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173
- Avoid Join Hints – SQL in Sixty Seconds #172
- One Query Many Plans – SQL in Sixty Seconds #171
Reference: Pinal Dave (http://blog.SQLAuthority.com)
