db_explain_query
Analyze SQL query execution plans to detect full-table scans, missing indexes, and performance bottlenecks before optimizing queries.
Instructions
Analyze query execution plan (EXPLAIN) to detect sequential full-table scans, missing indexes, and performance bottlenecks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL query to explain. | |
| params | No | Optional parameterized query values. |