analyze_index_usage
Identify and analyze unused or underutilized indexes in MSSQL databases to optimize performance by filtering specific tables, schemas, or showing only unused indexes.
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 |