4 ms·
If a table is constructed WITHOUT ROWID, then its spatial locality will reflect the consecutive order implied by the primary key. Range-delimited queries are e
by brandmeyer 6y ago
If a table is constructed WITHOUT ROWID, then its spatial locality will reflect the consecutive order implied by the primary key. Range-delimited queries are extremely fast.
In effect, SQLite already is both an OLTP and OLAP database.
- sanxiyn 6y agoAs you pointed out, SQLite does implement clustered index, but it is not columnar.