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.
The condition of the 'select' statement can be a logic operation on any of the column of the table and their combinations. I think that it may be better to create an index on each column. But I'm not so sure. -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users