SQLite Forum

Table and index in separate files
Login
Is it possible to have a table and index in separate files, like in the old dbase days...

I tried something like this with attach which doesn't work:

.open data.sqlite as datafile;
attach index.sqlite as indexfile;
create index indexfile.indexname on datafile.table(field);

Any other way or not at all possible?

CLI usage.

Philip