Storage metric - storage_table_unused_indexes
Closed this issue · 0 comments
lakshmi-udaan commented
Is your feature request related to a problem? Please describe.
Gives the user a view of table-level view of unused indices. Should also give appropriate recommendations.
Describe the solution you'd like
Use the DMV query to get the data. For recommendation, drop indexes with 0 seeks 0 lookups, 0 scans to save storage.