H002Needs investigationUnused index
- What we observed
- An index has no recorded scans in the observed period.
- Why it matters
- Every write still maintains it.
- What to try next
- Check statistics history, workload and constraints before deciding whether to remove it.