SQLite Forum

different query plan result when executed within transaction
Login
Not that I know of. AFAIK a query plan should depend on the schema and contents of the sqlite_stat* tables only, not whether or not a transaction is open.

Dan.