get_index_recommendations
Analyze database performance and generate index recommendations to optimize SQL Server queries and improve execution efficiency.
Instructions
Get index recommendations for database optimization
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (optional) | |
| schema | No | Schema name (optional, defaults to dbo) | |
| limit | No | Maximum number of recommendations to return (optional, defaults to 10) | |
| impact_threshold | No | Minimum impact score threshold (0-100, optional) |