SQLite Forum

different query plan result when executed within transaction
I wrote some code to automatically run each of my queries through explain query plan to check for full table scans.

This only runs while executing tests.

But I noticed that in some cases I get a different result when the eqp is executed within a transaction.  Specifically, when the eqp is run outside of the transaction it correctly shows a search using index.  When executed within a transaction it show a full table scan.

I can try to put together an example but thought I'd check ahead if there area any known issues around this.