Re: [sqlite] Multiple NATURAL JOIN precedence?

Thanks for your clarification, Pavel! > From: paiva...@gmail.com > Date: Wed, 7 Oct 2009 09:28:37 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Multiple NATURAL JOIN precedence? > > > Q: When joining two tables, does SQLite choose the smaller one as the &g

Re: [sqlite] Multiple NATURAL JOIN precedence?

, this yields a performance gain. > > > > > > Thanks. > > > > >> Date: Tue, 6 Oct 2009 20:33:17 -0700 >> From: dar...@darrenduncan.net >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] Multiple NATURAL JOIN precedence? >> >> Krist

Re: [sqlite] Multiple NATURAL JOIN precedence?

gain. Thanks. > Date: Tue, 6 Oct 2009 20:33:17 -0700 > From: dar...@darrenduncan.net > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Multiple NATURAL JOIN precedence? > > Kristoffer Danielsson wrote: > > All my tables have unique column names, so I tend to u

Re: [sqlite] Multiple NATURAL JOIN precedence?

Kristoffer Danielsson wrote: > All my tables have unique column names, so I tend to use "NATURAL JOIN" for > my joins (all join-columns are indexed). When I have multiple tables, I > sometimes get incredibly slow queries (not sure if they even terminate). If all of your tables have unique column

[sqlite] Multiple NATURAL JOIN precedence?

All my tables have unique column names, so I tend to use "NATURAL JOIN" for my joins (all join-columns are indexed). When I have multiple tables, I sometimes get incredibly slow queries (not sure if they even terminate). E.g. SELECT SUM(x) FROM t1 NATURAL JOIN t2 NATURAL JOIN t3 NATURAL