On 8 Apr 2014, at 2:22pm, Jens Miltner <j...@mac.com> wrote: > So what would cause SQLite not being able to use one of the two indexes I > have?
First, run "ANALYZE". Then run "EXPLAIN QUERY PLAN <whatever your SELECT is>". This may give you some clues about how SQLite is understanding your SELECT requirements when it works out a search strategy. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users