analyze_index_usage
Analyze SQL Server index usage statistics to identify unused or underutilized indexes, optimize 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 |
|---|---|---|---|
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| schema | No | Schema name (default: dbo) | |
| showUnusedOnly | No | Show only unused indexes (default: false) | |
| tableName | No | Filter by specific table name |