> Does anybody know whether it is possible to compress ... I don't recall anyone having claimed to have done this. You can try searching the archives:
<http://www.mail-archive.com/sqlite-users@sqlite.org/> > ... possible to create index organized tables within SQLite Not really. If you create an index on all your columns, SQLite will sometimes execute a select using only the index, but you'll be storing your data twice. Regards