investigate-statistics-issues
Use when row estimates are far from actual rows, statistics may be stale, or the user asks which to update or if auto-update keeps up. Has tested queries and rules common answers miss, e.g. the sqrt threshold needs compat level 130+. For missing indexes, use missing-index-analysis.
Pinned to revision 3224561abf68, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/investigate-statistics-issues/SKILL.md
- skills/investigate-statistics-issues/references/queries.md
- skills/investigate-statistics-issues/references/report-template.md
Every link opens the file at its source, pinned to the revision this page describes.