analyze_index_usage
Analyze SQL Server index usage statistics to identify unused or underutilized indexes, helping optimize database performance and reduce storage overhead.
Instructions
Show detailed index usage statistics to identify unused or underutilized indexes
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| schema | No | Schema name (default: dbo) | |
| tableName | No | Filter by specific table name | |
| showUnusedOnly | No | Show only unused indexes (default: false) |