list_indexes
Retrieve detailed information about all table indexes in a Microsoft SQL Server database, including usage statistics to analyze performance and optimize queries.
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) |