16 ms·

It never reconsiders? The one I have the most experience with (SQL server) certainly will, sometimes at weird times in ways that are non-obvious leading to perf

• maxbond 2y ago
  Poking at the documentation, they're only recompiled when the schema changes or ANALYZE has been run[1]. So, if you want them recompiled, you can use the optimize PRAGMA[2]. They raise a good point in the docs that in the contexts SQLite works in, if there's a regression caused by changing the plan, there won't be a DBA around to fix it. [1] https://sqlite.org/queryplanner-ng.html https://sqlite.org/queryplanner-ng.html [2] https://sqlite.org/lang_analyze.html#req https://sqlite.org/lang_analyze.html#req