Is there a way to skip "unused" indexes based on the total reads of that index during an index maintenance w/ Ola's scripts?
I understand that
- Index stats are only since the last restart, so monitoring over a business cycle is important
- Skipping a reorg or rebuild on an "unused" index which may be needed later, even once, in the business cycle could cause performance issues
- Everyone's thinking "why don't you just remove it"
To answer the latter, it's a vendor supplied application w/ an OLTP DB of ~2TB. To stay compliant, we can't change much and I can't drop their indexes among other things. Thus, I thought it'd be beneficial to reduce the maintenance time by skipping these indexes once I've confirmed they aren't ever used. This would be beneficial for situations where, like this, my hands are mostly tied.
Follow on for comments would be if this isn't able to be done, is it worth tossing to Ola as an enhancement?