THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
SCOPE and KIND are two orthogonal enums to categorize a PlanAdvice.
| KIND | NOTE |
|---|---|
| WARNING | It reveals potential data correctness risks, such as state expiration, and NDU issues |
| ADVICE | It suggests potential SQL optimizer tuning configuration, such as enabling mini-batch to optimize to two_phase aggregation |
| SCOPE | NOTE |
|---|---|
| QUERY_LEVEL | It provides advice from a global view, targeting the entire query. |
| NODE_LEVEL | It provides advice to a specific rel node. |
The current explain result is illustrated in the SQL Explain Result. When ExplainDetails contain PLAN_ADVICE, the output format will be like
...