On 16 Sep 2019, at 5:58pm, Jens Alfke <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
