Explain Query
explain_queryGet a CUBRID execution plan for a SELECT or WITH statement to identify full table scans (SEQ SCAN) and optimize query performance with indexes.
Instructions
Return CUBRID's execution plan/trace for a SELECT or WITH statement.
CUBRID uses SHOW TRACE (not standard EXPLAIN). Look for SEQ SCAN in the output — it indicates a full table scan that may benefit from an index. See cubrid://guide/performance for interpretation tips.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| connection | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||