2018-08-30 8:13 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>: > > Slightly more efficient code is generated for the BETWEEN version (the LHS > of the between is only calculated once). It is also somewhat easier to > read. >
That is the primary reason to use BETWEEN, but it does not hurt that it is more efficient. ;-) > sqlite> select x from x where x between 1 and 10; > QUERY PLAN > I should learn to read QUERY PLAN's. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
