4 ms·
Dolt's EXPLAIN output prints the execution tree directly. E.g.: explain select * from xy join uv on (x = u and u > 0) where u < 2; Project ├─ col
by zachmu 2y ago
Dolt's EXPLAIN output prints the execution tree directly. E.g.:
explain select * from xy join uv on (x = u and u > 0) where u < 2;
Project
├─ columns: [xy.x:2!null, xy.y:3, uv.u:0!null, uv.v:1]
└─ LookupJoin
├─ IndexedTableAccess(uv)
│ ├─ index: [uv.u]
│ ├─ static: [{(0, 2)}]
│ ├─ colSet: (3,4)
│ ├─ tableId: 2
│ └─ Table
│ ├─ name: uv
│ └─ columns: [u v]
└─ IndexedTableAccess(xy)
├─ index: [xy.x]
├─ keys: [uv.u:0!null]
├─ colSet: (1,2)
├─ tableId: 1
└─ Table
├─ name: xy
└─ columns: [x y]