Simon Slavin schrieb am 24.08.2011 22:38: > On 24 Aug 2011, at 6:59pm, GB wrote: > >> SELECT itemID FROM t WHERE itemID BETWEEN 1000000 AND 2000000 AND >> createdAt BETWEEN '2011-08-01' AND '2011-08-02' > Just out of curiosity, try changing both the BETWEEN formulations so it says > > SELECT itemID FROM t WHERE itemID>= 1000000 AND itemID<= 2000000 AND > createdAt>= '2011-08-01' createdAt<= '2011-08-02' > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
Thank you for your thoughts but I already tried this with no different results than before. And according to http://www.sqlite.org/optoverview.html#between_opt this is exactly what happens behind the curtains when SQLite processes BETWEEN statements. What I'm actually looking for is a way to make SQLite create and consider histogram data for rowid lookup the same way as for regular indexes. regards gerd _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users