On Oct 22, 2011, at 3:17 PM, Fabian wrote: > So is there some way to have a 'stand-alone index', which doesn't store > everything twice?
Not in SQLite, no. Other databases (such as Oracle) sometime offer so-called Index Organized Table (IOT). http://www.orafaq.com/wiki/Index-organized_table _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users