On Sep 26, 2008, at 2:29 PM, Kees Nuyt wrote: > On Fri, 26 Sep 2008 12:54:36 -0400, Russell wrote: > >> I need a 2 key index for some queries and also want to aggregate on >> these 2 columns. I need this index BUT I have many large sqlite dbs I >> iterate over and they won't fit in the filesystem cache. Run time >> when >> the index is present is 105min. Run time with out the index is 3min. > > Did you populate the sqlite_stat1 index statistics table > with ANALYZE ? It might influence the query plan.
Yup. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
