3 ms·
Any possibility to also add index to a virtual table in SQLite? Normally you can’t: https://sqlite.org/vtab.html https://sqlite.org/vtab.html
by punnerud 5y ago
Any possibility to also add index to a virtual table in SQLite? Normally you can’t: https://sqlite.org/vtab.html https://sqlite.org/vtab.html
- frabert 5y agoYou could just INSERT INTO regular_table SELECT * FROM csv_table and then create an index for regular_table
- codemonkey-zeta 5y agoGenuine question - why start with a virtual table at all in this case? Why not just import the data to regular_table from the csv file?
- CRConrad 5y agoApparently this is for when you decide not to create indexes etc on the data, presumably to save disk space or something.