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 optimi

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