> On Oct 16, 2016, at 4:49 AM, Luuk <luu...@gmail.com> wrote: > > Because your second query has to build the complete view before it can decide > if a result is between the selected dates?
I didn’t think a view had a physical manifestation that had to be built; I thought it was just a shortcut/macro for a nested SELECT statement. Or is the query optimizer not able to convert the nested SELECT into the same form as the first query? —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users