3 ms·
SQLite EXPLAIN plan is indeed represented as a table, but I don’t find it necessarily that much easier to read and understand. I often miss having the cardinal
by jiehong 2y ago
SQLite EXPLAIN plan is indeed represented as a table, but I don’t find it necessarily that much easier to read and understand.
I often miss having the cardinality and the amount of bytes read for each part of the query like Oracle query plans provide.
Or is everyone really that happy with SQLite query plans?
- bvrmn 2y agoThere is EXPLAIN QUERY PLAN which outputs usual high level plan description. But there is no easily reached disk/cache usage stats.