analyze_workload_indexes
Analyze frequently run database queries to identify missing or redundant indexes and receive index recommendations that improve query performance.
Instructions
Analyze frequently executed queries in the database and recommend optimal indexes
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| method | No | Method to use for analysis | dta |
| database | No | Optional. Alias of the configured database to query. Omit it when the server has only one database configured. When several are configured this parameter is required - call list_databases first to learn the valid aliases. | |
| max_index_size_mb | No | Max index size in MB |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |