EXPLAIN MEMO

Returns the internal structure Memo of the query.

Syntax

EXPLAIN MEMO <query_statement>

Examples

EXPLAIN MEMO SELECT * FROM numbers(10) t, numbers(100) t1;

 ----
 Group #0                            
 ├── best cost: [#1] 10              
 ├── LogicalGet []                   
 └── PhysicalScan []                 
                                     
 Group #1                            
 ├── best cost: [#1] 100             
 ├── LogicalGet []                   
 └── PhysicalScan []                 
                                     
 Group #2                            
 ├── best cost: [#3] 310             
 ├── LogicalInnerJoin [#0, #1]       
 ├── LogicalInnerJoin [#1, #0]       
 ├── PhysicalHashJoin [#0, #1]       
 └── PhysicalHashJoin [#1, #0]