list_indexes
Retrieve detailed information and usage statistics for all indexes on SQL Server tables to optimize database performance and manage schema efficiently.
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 |