On 8 Apr 2014, at 2:22pm, Jens Miltner <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
