Hello! I have the problem that one index is not taken into account when I execute a query:
I have 1 table with 2 columns. Each column has an index, but EXPLAIN QUERY PLAN tells me that the second index is not being used. ------ First column: name: mycolumn1 type: text collation: nocase unique: yes First column index: name: idx_mycolumn1 collation: nocase unique: yes ------- Second column: name: mycolumn2 type: text collation: - unique: false Second column index: name: idx_mycolumn2 collation: - unique: false ------ Results for "SELECT * FROM mytable WHERE mycolumn1 LIKE 'a%'": 1: 0 2: TABLE mytable WITH INDEX idx_mycolumn1 Results for "SELECT * FROM mytable WHERE mycolumn2 LIKE 'a%'" 0 TABLE mytable Can anybody tell me why and how I can change this? Thank you. -- Regards, Bert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
