📄️ EXPLAIN AST
Returns the abstract syntax tree (AST) of a SQL statement. The command breaks a SQL statement into syntactic parts and represents them in a hierarchical structure.
📄️ EXPLAIN FRAGMENTS
Shows the distributed execution plan of a SQL statement.
📄️ EXPLAIN RAW
Shows the logical execution plan of a SQL statement that you can use to analyze, troubleshoot, and improve the efficiency of your queries.
📄️ EXPLAIN SYNTAX
Outputs formatted SQL code. This command works as a SQL formatter that makes your code easy to read.
Shows the execution plan of a SQL statement with statistics, such as the number of rows to read, and the number of storage partitions to scan.