benchmark_tuning_candidate
Benchmark a SQL rewrite candidate against baseline using interleaved exactly-once samples and snapshot-consistent duplicate-aware comparison to verify correctness and assess performance.
Instructions
Benchmark one rewrite candidate with interleaved, exactly-once samples and snapshot-consistent duplicate-aware result comparison.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runs | No | Optional paired runs per parameter case. Screening is capped by the session screening limit; finalists by the finalist limit. | |
| phase | No | Benchmark phase: screening or finalist. | screening |
| session_id | Yes | Tuning session identifier. | |
| decision_id | No | ||
| baseline_sql | Yes | Baseline read-only SQL. | |
| candidate_id | Yes | Candidate identifier. | |
| candidate_sql | Yes | Candidate read-only SQL. | |
| compare_order | No | ||
| database_name | No | ||
| idempotency_key | No | ||
| parameter_cases | No | Exact unchanged subset of the performance-case parameter inputs. | |
| prove_equivalence | No | Defaults false for broad screening and true for finalists. Finalists cannot disable full snapshot equivalence. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| headline | Yes |