SQLite Forum

Table and index in separate files
If you insist on having data and index in separate files, then you need to implement a virtual table module that uses this kínd of storage model. Faircom CTree comes to mind - but that would require a separate file for each table too.