On 16 Sep 2019, at 5:58pm, Jens Alfke <j...@mooseyard.com> wrote: > Experimentally, the optimizer seems to choose an index search even with the > simpler query. I ran this on a test database with about 30k rows.
In case you forgot I'm just reminding you to run ANALYZE after putting your data and indexes in. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
