2011/10/12 Dan Kennedy <danielk1...@gmail.com> > > Can we see the output of EXPLAIN for this query? >
> Without selecting table2.data2: 0 0 0 SEARCH TABLE table1 USING INDEX data1idx (data1=?) (~3 rows) Including selecting table2.data2: 0 0 0 SEARCH TABLE table1 USING INDEX data1idx (data1=?) (~3 rows) 0 1 1 SCAN TABLE table2 VIRTUAL TABLE INDEX 1: (~0 rows) So it looks like the whole problem is caused by the 'SCAN' on table2. Is there any reason why SQLite does this SCAN instead of a SEARCH, since I JOIN the two tables on ROWID, why does it have to do a full table scan? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users