benchmark_index_candidate
Benchmarks a disposable index candidate on Azure SQL by measuring query performance before and after, in a policy-allowlisted sandbox with automatic durable cleanup.
Instructions
Benchmark a leased disposable index in a policy-allowlisted sandbox. Cleanup is automatic and cleanup failures are durable.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only query measured before and after the index. | |
| phase | No | Benchmark phase: screening or finalist. | screening |
| online | No | ||
| is_unique | No | ||
| session_id | Yes | Tuning session identifier. | |
| table_name | Yes | Target table. | |
| decision_id | No | ||
| key_columns | Yes | Ordered key columns, optionally ASC/DESC. | |
| schema_name | Yes | Target schema. | |
| candidate_id | Yes | Index candidate identifier. | |
| compare_order | No | Preserve ordered-result semantics during A-B-A stability checks. | |
| database_name | No | ||
| lease_minutes | No | ||
| idempotency_key | Yes | Caller-generated key used to fence retries and cleanup. | |
| include_columns | No | ||
| parameter_cases | No | The same named parameter cases recorded on the performance case. | |
| filter_definition | No | Optional filtered-index predicate; no SQL statements or comments. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| headline | Yes |