> On Oct 25, 2018, at 10:45 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > There is an extra column load and compare when using the between version of > the query (this is because although the optimization of the index use is the > same, the use of x BETWEEN y AND z adds both the y <= x and x <= z checks as > where clause tests that are executed within the loop, whereas when using the > devolved query (the later form) one of the constraints is used against the > index and only the other one is tested.
This seems like an optimization opportunity … is it already a known issue, to be addressed in the query optimizer at some point? —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users