I don't know when/if this will be available. It certainly would make some sense, with overrides from the DBA. There are indexes that are lightly used (in frequency), but very valuable. How do you determine what's not used enough?

The same for fragmentation. It's fine for it to run continuously in the reorganize mode, but sometimes you might need a rebuild. That is a relatively expensive operation and you might not want that to occur without approval.

Some of these indexing issues aren't easy to solve from the "how should it work" perspective. The code is easy, but the decisions are hard.