Hello MS> CREATE TABLE tx (name TEXT, type INTEGER, seq INTEGER, seq_record TEXT, MS> ...);
MS> CREATE INDEX IDX1 on tx(name ASC); MS> CREATE INDEX IDX2 on tx(type, search_name ASC); The two indexes cover different columns, so they do different things. The indexes you need depend on the queries you will be doing, so there is no way I can tell if you need these indexes. Columns which are used in WHERE clauses are good candidates for indexing, generally speaking. You don't show a column called search_name in the CREATE TABLE line. I assume there is one. A more specific answer would require more information, but I hope this helps. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
