On Sep 14, 2011, at 8:40 PM, Igor Tandetnik wrote: > Think about it this way. You have a phone book, where names are sorted by > last name, then first name. You want to find all people whose last name is > greater than 'Smith' and first name less than 'John'. The alphabetic order > helps you with the first half, but not really with the second half - names > satisfying both conditions don't appear sequentially in the list.
Ah, yes, I wish SQLite supported bitmap indices :)) 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
