Inefficient Indexes
An index is considered Inefficient if it has many updates, and not so many seeks, scans or lookups. This is an indication that the index isn’t being used much and that it is being updated often.
Just because an index is inefficient, doesn’t mean it should be deleted, it should be considered for removal. It might be that an index is inefficient but it is used in a report that the CEO uses once a month, in which case it should probably not be removed.
You can find the opposite of this report, the most used indexes in the Most Used Indexes report.
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Contact Info
Stedman Solutions, LLC.PO Box 3175
Ferndale WA 98248
Phone: (360)610-7833
Download this page in PDF format
Leave a Reply