Statistics Maintenance Review
Use this skill when statistics_age.csv or stale-statistics findings are present.
Workflow
- Identify high modification ratios.
- Correlate stale statistics with top queries, Query Store, and plan variance.
- Recommend targeted statistics validation in an approved window.
- Measure before/after reads, CPU, duration, and plan stability.
Related Scripts
analyze_evidence.pygenerate_validation_scripts.pyoptimize_maintenance_window.py