2010/7/18 Peng Yu <[email protected]>: >>> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
