Aaron Bertrand talks index maintenance of a different sort:
I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about how non-clustered indexes are expensive to store and maintain, that they can occupy valuable space in memory, and that they can negatively impact the performance of the write portion of any SQL Server workload. There are great scripts out there already – like
sp_BlitzIndex– that can help identify index issues without any grunt work. So, nothing new in this area.But reinforcement can be beneficial.
Aaron raises some good points and explains why simply deleting any index with 0 reads is not necessarily a good idea. All bets are off, however, when you see 45 indexes on the same table with the same dta_ prefix.