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?