On 10/12/2011 09:39 PM, Fabian wrote:
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?
(INDEX 1) == lookup by rowid.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
