Tristan, My apologies to you and the list if you mentioned this earlier, but I assume you've run the analyze command on your database, right?
http://www.sqlite.org/lang_analyze.html Also possibly relevant: http://www.sqlite.org/compile.html#enable_stat3 (Of course, Igor's suggestion of the uninary "+" to sent a hint to the sqlite query planner gives an immediate solution to your particular question.) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
