> 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

Reply via email to