4 ms·

I hope SQLite's EXPLAIN were more visual / tree-like. Using bytecode internally is fine, but what users care is typically more high level. Decoding the that hig

I hope SQLite's EXPLAIN were more visual / tree-like. Using bytecode internally is fine, but what users care is typically more high level. Decoding the that high level intention from the bytecode is so burdensome that I often give up and just fall back to try-n-error.

carry_bit 4y ago
If you use EXPLAIN QUERY PLAN rather than just EXPLAIN, you get a high level description of the plan rather than the bytecode.
- flakiness 4y ago
  Great to know! Thanks!