On May 17, 2013, at 10:54 AM, Konstantinos Alogariastos <marau...@gmail.com> wrote:
> Does this mean that one cannot use a index on two columns when in the query > both columns are used with "IN"? You might want to read up on the query planner: http://www.sqlite.org/queryplanner.html#searching The short of it: only one btree index will be used per source table. > Is this a limitation of SQLite or a bug? Neither. But read up on Multi-Column Indices. There exist other types of indexes (for example bitmap indexes [1]), which have different properties and can be combined to resolve a query, but such structures are not supported by SQLite. [1] http://en.wikipedia.org/wiki/Bitmap_index _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users