On Mon, 04 Mar 2019 20:20:08 -0700 "Keith Medcalf" <kmedc...@dessus.com> wrote:
> In the first query the subselect that creates the list is independent. > In the second query the subselect that creates the list is correlated. Yes, and if it can be shown that the two queries are logically equivalent under relational algebra, then it's theoretically possible for the query planner to have arrived at the same plan in both cases. That is the only test that could support/deny the assertion that they could be rendered according to the same execution plan. > In the first query you have requested that the subquery be executed > to create the list for use by the IN operator. No. The query requests no such thing. SQL makes no request or suggestion for how to execute a query. It simply describes a result. It's up to the implementation to determine how to produce that result. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users