under section 10.0 Query Flattening
Your query is:
SELECT * FROM <view> WHERE <condition>
which could be treated as
FROM (view select statement)
and then flattened. Note however that the query WILL NOT be flattened because
of rule #2, the subselect in the FROM clause contains an aggregate ...
> -----Original Message-----
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Jens Alfke
> Sent: Sunday, 16 October, 2016 12:17
> To: SQLite mailing list
> Subject: Re: [sqlite] Why takes the second SELECT three times as much
> > 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
sqlite-users mailing list