> 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?
sqlite-users mailing list