Explain query execution plan
hana_explain_planRun EXPLAIN PLAN for SELECT/WITH queries and get the operator tree from EXPLAIN_PLAN_TABLE to see how SAP HANA executes the statement.
Instructions
Run EXPLAIN PLAN for a SELECT/WITH query and return operator tree from EXPLAIN_PLAN_TABLE. Only SELECT/WITH are accepted.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query": "<query>"
},
"name": "hana_explain_plan"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SELECT or WITH query to explain (must not contain DML/DDL) |