get_missing_index_impact
Aggregate missing-index recommendations from SQL Server Query Store plans, rank them by optimizer-estimated impact, and group duplicates across queries.
Instructions
Aggregate missing-index recommendations found in Query Store plans, ranked by the optimizer's estimated impact score. Groups duplicate recommendations across queries.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"database_name": "<database_name>"
},
"name": "get_missing_index_impact"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | Max index recommendations to return. | |
| database_name | Yes | Target SQL Server database name. | |
| plan_scan_limit | No | How many recent plans (that contain missing indexes) to scan and aggregate. Higher = more thorough, slower. |