list_indexes
Retrieve detailed information and usage statistics for all indexes on MSSQL tables, filtered by schema or table, to optimize database performance.
Instructions
List all indexes on tables with usage statistics and detailed information
Input Schema
TableJSON 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 |