2010/7/18 Peng Yu <pengyu...@gmail.com>: >>> This question may be trivial. But I'm wondering, whether I should >>> create one index on multiple columns or create multiple indexes, each >>> of which is on a single column. > > select * from test group by value1,value2; > select * from test group by value1||value2; > > For this case, what is the best way to create the index? > -- > Regards, > Peng
1. create index test1 on (value1,value2); create index test2 on (value2); 2. Try EXPLAIN. -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
