# Statistics Maintenance Review

> Analyze stale SQL statistics, modification counters, plan risk, and maintenance-window recommendations for AX workloads.

- Skill: `rweisssieker-xp/statistics-maintenance-review` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/statistics-maintenance-review`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/statistics-maintenance-review/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/statistics-maintenance-review

---


# Statistics Maintenance Review

Use this skill when `statistics_age.csv` or stale-statistics findings are present.

## Workflow

1. Identify high modification ratios.
2. Correlate stale statistics with top queries, Query Store, and plan variance.
3. Recommend targeted statistics validation in an approved window.
4. Measure before/after reads, CPU, duration, and plan stability.

## Related Scripts

- `analyze_evidence.py`
- `generate_validation_scripts.py`
- `optimize_maintenance_window.py`