Feature
New diagnostic checks for statistics that are being maintained for zero benefit:
- Stats attached to disabled indexes — updated on every run, never used by the optimizer.
- Hypothetical indexes / stats (
is_hypothetical = 1, typically DTA leftovers) — should be flagged for cleanup, not maintenance.
- Duplicate leading-column statistics — multiple stats whose histograms share the same leading column on the same table (auto-created column stat shadowed by an index stat); maintenance cost is duplicated for one histogram's worth of value.
Each finding should include the reversible remediation (e.g. DROP STATISTICS for the redundant auto-created stat) with evidence.
Pattern source: sp_IndexCleanup's metadata funnel (DarlingData).
Feature
New diagnostic checks for statistics that are being maintained for zero benefit:
is_hypothetical = 1, typically DTA leftovers) — should be flagged for cleanup, not maintenance.Each finding should include the reversible remediation (e.g. DROP STATISTICS for the redundant auto-created stat) with evidence.
Pattern source: sp_IndexCleanup's metadata funnel (DarlingData).