analyze_workload_indexes
Analyzes frequent queries to recommend optimal indexes, improving database performance by reducing query execution time.
Instructions
Analyze frequently executed queries in the database and recommend optimal indexes
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max_index_size_mb | No | Max index size in MB | |
| method | No | Method to use for analysis | dta |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |