hello, I have a table T (a,b,c,d,t) where c is a value a,b,c some dimensions and t the time
I need to make a subset with a "group by" like select a,b,c,sum(d) from T where t>x1 and t<x2 group by a,b,c I created an index on a,b,c but this table is large and the index creation is time consuming (few hours) please could you let me know which index could be better or faster? also do you know by chance how to speed up the index creation? Best regards, Sylvain _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users