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

Reply via email to