analyze_index_usage
Optimize SQL Server performance by identifying unused or underutilized indexes. Filter by schema, table, or show only unused indexes for targeted database tuning.
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 |