Analyze Index Usage
analyze_index_usageIdentify unused and underutilized indexes using detailed usage statistics. Improve database performance by removing or adjusting inefficient indexes.
Instructions
Show detailed index usage statistics to identify unused or underutilized indexes
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema name (default: dbo) | |
| tableName | No | Filter by specific table name | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| showUnusedOnly | No | Show only unused indexes (default: false) |