On Nov 26, 2012, at 12:30 AM, Jay A. Kreibich <j...@kreibi.ch> wrote:
> "Using SQLite" (http://shop.oreilly.com/product/9780596521196.do) > has a very lengthy discussion of indexes and how they work, > specifically because it is difficult to generalize the use of > indexes. One must really look at each application and each database > (and the data in that database!) with a solid knowledge of what an > index can-- or cannot-- provide in order to find places where an > index will make a positive difference. All true, and well articulated. But, at the end of the day, SQLite only provides b-tree indexes and that is that. And b-trees are not that useful and/or detrimental for a wide range of use case. What about providing bitmap indexes? http://en.wikipedia.org/wiki/Bitmap_index Bitmap Index vs. B-tree Index: Which and When? http://www.oracle.com/technetwork/articles/sharma-indexes-093638.html Now, that would be a breakthrough :) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
