Automatic tuning – Azure SQL Drop Indexes

Careful about enabling his , it can still report the duplicates and then the indexes can be evaluated to see if they are indeed duplicates. If they identical BTREE and INCLUDE and they are not supporting uniqueness or foreign key then they can be removed manually. Doesn’t seem to be too many dups identified.

In addition, if an index has not been used for 90 days or more then there is always a chance that there is a report (run 6 monthly or yearly) or end of year process that requires the index, in this case the index should be evaluated by the vendor before being dropped.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)