SQLite Forum

JOINs with FTS5 virtual tables are very slow
Login
If you run "ANALYZE" so that SQLite can see that the (deleted=0) condition matches a large percentage of the table, does it come up with a better plan for query 1?