3 ms·
If you will kindly send your problem query to the SQLite developers, we will do what we can to improve the query planner to make it run faster.
by SQLite 7y ago
If you will kindly send your problem query to the SQLite
developers, we will do what we can to improve the query planner
to make it run faster.
- Izkata 7y agoPosted (and reran the numbers with some unnecessary transformations removed): https://sqlite.org/forum/forumpost/e4091b433a https://sqlite.org/forum/forumpost/e4091b433a I may have misremembered since I did go a bit wild on this query (done while learning about recursive queries), but pulling the subquery into a CTE doesn't affect the query plan.