list_indexes
Retrieve comprehensive details about SQL Server table indexes, including usage statistics, to analyze database performance and optimize query execution.
Instructions
List all indexes on tables with usage statistics and detailed information
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| schema | No | Schema name (default: dbo) | |
| tableName | No | Filter by specific table name | |
| includeUsageStats | No | Include index usage statistics (default: true) |