Eleytherios Stamatogiannakis wrote: > 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.
Well, what does your xBestIndex callback return? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users