List Table Indexes
list_indexesList all indexes on database tables with usage statistics and detailed information to analyze index performance and usage.
Instructions
List all indexes on tables with usage statistics and detailed information
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') | |
| includeUsageStats | No | Include index usage statistics (default: true) |