On 14/03/13 17:05, Clemens Ladisch wrote:
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?
The "INDEX 0:" is always there (even when no index is defined in the VT
function). I don't know what it means.
l.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
