On 21 Apr 2017, at 8:57pm, Kim Gräsman <kim.gras...@gmail.com> wrote:
> There is a WHERE clause, but EXPLAIN QUERY PLAN does not mention any indexes: > > sele order from deta > ---- ------------- ---- ---- > 0 0 0 SCAN TABLE mytable > > Also, this is just one of many (hundreds) statements, and I don't have > a good way to audit all of them. You're essentially saying that any > statement may allocate pages corresponding to an index for filtered > columns... I can see how that can get large, quickly. The 'SCAN' means it’s just reading every row of the table, checking to see which ones fit your WHERE clause. This doesn’t involve any indexes, so you’re okay here. I don’t know enough about SQLite to answer the rest of your post. I hope someone else where will. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users