plan-analysis
Use when the user supplies an execution plan (showplan XML, .sqlplan) or asks to explain or check one: costly operators, spills, misestimates. Has tested rules common answers miss, e.g. subtree costs are inclusive. For end-to-end tuning, use improve-query-performance.
Pinned to revision 3224561abf68, so it is the text this page describes rather than whatever the author pushed since.
Files
Every link opens the file at its source, pinned to the revision this page describes.