analyze_index_usage
Identify unused or underutilized indexes in MSSQL databases to optimize performance and storage. Analyze detailed index usage statistics by schema, table, or connection.
Instructions
Show detailed index usage statistics to identify unused or underutilized indexes
Input 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 |