When trying to make SQLite pick the right index, please use this sequence. 1) Create your indexes. 2) Put typical example data in your table. 3) Use the ANALYZE command 4) Delete the test data and put in real data (optional)
You can do (1) and (2) in any order. But having data in the table makes a difference, and leads to better results than doing ANALYZE with empty tables. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users