Viewing the Execution Plan¶
Function¶
This statement returns the logical plan and physical execution plan for the SQL statement.
Syntax¶
EXPLAIN [EXTENDED | CODEGEN] statement;
Keywords¶
EXTENDED: After this keyword is specified, the logical and physical plans are outputted at the same time.
CODEGEN: After this keyword is specified, code generated by using the Codegen is also outputted.
Precautions¶
None
Example¶
To return the logical and physical plans of SELECT * FROM test, run the following statement:
EXPLAIN EXTENDED select * from test;