find_missing_indexes
Identify and analyze missing indexes in Microsoft SQL Server to optimize query performance based on execution patterns. Specify connection details, schema, and impact threshold for precise results.
Instructions
Identify potentially missing indexes based on query execution patterns
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
connectionString | No | SQL Server connection string (uses default if not provided) | |
minImpact | No | Minimum impact score to include (default: 1000) | |
schema | No | Schema name (default: dbo) |