On 16 Aug 2011, at 9:39am, Filip Navara wrote: > create table a (a, b, c, d); > create index aIdx on a (a, d); > > Now the data in columns "b" and "c" can be pretty large. Let's make > the following query: > > select a, d from a; > > Full-table scan is done even if an index exists that covers all the > data required by the query.
That's a little strange. Please execute the SQL command ANALYZE on that database. Then do your 'EXPLAIN' tests again. It won't fix the problem but it'll tell us something useful. http://www.sqlite.org/lang_analyze.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
