analyze_index_usage
Identify unused or underutilized SQL Server indexes to 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) |