explain_query
Analyze SQL query performance by generating an estimated execution plan without executing the query. Understand query behavior and indexing needs safely.
Instructions
Generates an estimated execution plan (SHOWPLAN_XML) for a SQL query without executing it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL statement to analyze (typically SELECT/UPDATE/INSERT/DELETE). | |
| environment | No | Optional environment name to target (prod, staging, etc). | |
| includePlanXml | No | If true (default), returns the raw SHOWPLAN XML. Set false for summary only. |