prepare_plan_action
Prepare and persist a reviewed plan-action intent for Azure SQL Query Store, capturing control state and evidence for human-approved tuning operations like force plan or apply hints.
Instructions
Capture exact Query Store control state and persist a reviewed, redacted plan-action intent. Automatic Tuning ownership is review-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| reason | Yes | Reviewed reason for the action. | |
| plan_id | No | ||
| evidence | Yes | Reviewed pre-change evidence window. | |
| query_id | Yes | Query Store query_id. | |
| operation | Yes | force_plan, unforce_plan, set_hints, or clear_hints. | |
| session_id | Yes | Shared tuning session identifier. | |
| query_hints | No | ||
| reviewed_by | Yes | Human reviewer identifier. | |
| candidate_id | No | ||
| database_name | No | ||
| idempotency_key | Yes | Unique idempotency key. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||