Indexing for Delete – SQL in Sixty Seconds #197


 

In Comprehensive Database Performance Health Check, I often discuss that indexes can reduce the performance of your system big time. Many still think that indexes are good for a SELECT statement but that is not true and I have previously created a video on that topic as well as discussed it in depth during the health checks. Today we are going to see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete.

Let me know what you think of this video about Indexing for Delete.

Here are