Thanks, I really appreciate so fast responce. However, example above still doesn't work: planner prefers index 'a' instead of TABLE SCAN for WITHOUT ROWID table, when range of query covers full table.
-- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users