You can get SQLite to show exactly what it's doing using "explain", see http://sqlite.org/opcode.html
On Thu, Jun 25, 2015 at 10:16 PM, Sairam Gaddam <gaddamsairam at gmail.com> wrote: > I know that SQLite will perform some internal select statements when > executing a join query but will it break a join query and execute in parts > ??? > > For example if I join 10 tables, will it perform join of 8 and 2 tables at > once and in turn join the result of those two joins? > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
