benchmark_query_rewrite
Benchmark a baseline SQL query against a proposed rewrite using actual plan samples and snapshot equivalence to validate performance improvements.
Instructions
Benchmark a baseline query against a proposed rewrite using the same typed read-only execution path, interleaved actual-plan samples, and complete bounded snapshot equivalence.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runs | No | Screening executions per side (2-3). Metrics become per-run medians with min/max spread, so a single lucky run cannot masquerade as a win. The workflow does not clear Azure SQL caches. | |
| analyze | No | When true, execute both queries to capture actual plans. | |
| rewrite_sql | Yes | Candidate semantically equivalent rewrite. | |
| baseline_sql | Yes | Original read-only SQL query. | |
| compare_order | No | Compare result rows in returned order. Set false only when the query contract does not require ordering. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. | |
| include_raw_xml | No | Include raw SHOWPLAN XML inline. Defaults to artifact URI only. | |
| parameter_types | No | Optional exact SQL types shared by baseline and rewrite. | |
| auto_bind_params | No | Bind @param placeholders from column statistics where possible. | |
| parameter_values | No | Explicit parameter values for both baseline and rewrite. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| headline | Yes |