list_indexes
Retrieve detailed information and usage statistics for all indexes on SQL Server tables, enabling efficient database optimization and analysis. Supports filtering by table and schema.
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 |