On Fri, Apr 22, 2016 at 6:55 PM, Richard Hipp <drh at sqlite.org> wrote:
> On 4/22/16, Dimitris Bilidas <d.bilidas at di.uoa.gr> wrote: > > SELECT count(qview1."wlbWellboreName") FROM "discovery" qview2 CROSS > > JOIN "wellbore_development_all" qview1 WHERE > > (qview1."wlbNpdidWellbore" = qview2."wlbNpdidWellbore"); > > You are aware that SQLite uses the CROSS JOIN syntax as a way of > controlling the query planner, and limiting the number of options that > the query planner looks at, right? (See > https://www.sqlite.org/optoverview.html#crossjoin for more > information.) I don't think this is important here, but it might be. Thanks for the reminder. And very interesting. --DD PS: Small typo: reads "But algorithm-2 really is the correct choice here", but "But algorithm-1 really is the correct choice here" is meant I believe.
