Select Page

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.

Submit a Comment

Your email address will not be published. Required fields are marked *

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.