On Oct 9, 2011, at 1:03 PM, Black, Michael (IS) wrote: > For your example create a separate table with just the first letter and build > an index on it.
This is most likely pointless as the selectivity of such index is going to be very low. Plus not point in reinventing a square wheel, instead let FTS handle this :) FTS4 supports prefix queries: http://www.sqlite.org/fts3.html#section_6_2 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
