Eleytherios Stamatogiannakis wrote: >> explain query plan select * from t1, t2 where t1.c1=t2.c1; > 0 |0 |1 | SCAN TABLE t2 (~1000000 rows) > 0 |1 |0 | SCAN TABLE t1 VIRTUAL TABLE INDEX 0: (~0 rows) > > Even thought, i have put VT t1 first in the join list, SQLite > will do a nested loop join (putting it on the right).
How have you defined index 0 of your virtual table? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users