explain_query
Compile a query to an estimated plan, surfacing expensive operators, big-table scans, key lookups, sorts, implicit conversions, warnings, and missing-index suggestions without executing it.
Instructions
Estimated execution plan, summarised: the expensive operators, scans on big tables, key lookups, sorts, implicit conversions, optimizer warnings and missing-index suggestions. The query is compiled, NOT executed, so this is safe on heavy queries. (SQL Server login needs the SHOWPLAN permission.)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | ||
| query | No | ||
| params | No | ||
| connection | No |