get_index_recommendations
Analyze SQL Server databases to identify missing indexes that improve query performance and optimize database operations based on impact scoring.
Instructions
Get index recommendations for database optimization
Input Schema
Name | Required | Description | Default |
---|---|---|---|
database | No | Database name (optional) | |
impact_threshold | No | Minimum impact score threshold (0-100, optional) | |
limit | No | Maximum number of recommendations to return (optional, defaults to 10) | |
schema | No | Schema name (optional, defaults to dbo) |