list_indexes
Retrieve detailed information and usage statistics for all indexes on specific tables in a Microsoft SQL Server database, enabling efficient index management and optimization.
Instructions
List all indexes on tables with usage statistics and detailed information
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) | |
| includeUsageStats | No | Include index usage statistics (default: true) | |
| schema | No | Schema name (default: dbo) | |
| tableName | No | Filter by specific table name |