Community
Loading...
Posted inSQL
Microsoft
6 years ago

Explain why indexes were skipped

Feature request: expose information about what indexes the optimizer considered while compiling an execution plan. Specifically, the index names and WHY the index was rejected for that particular query. This could potentially be included in per-operator execution plan properties (see attached mockup), an extended event target, or some other avenue.
Under Review
Query Processing and Intelligent DatabaseSuggestions

2 Comments

You must to comment
Erik Darling11 months ago
0 Reports0
Conor Cunningham1 year ago
0 Reports0