SQLite Forum

Defragment a table ?
On the [without rowid page](https://www.sqlite.org/withoutrowid.html) there's this line down in section 4:

> WITHOUT ROWID tables will work correctly (that is to say, they provide the correct answer) for tables with a single INTEGER PRIMARY KEY. However, ordinary rowid tables will run faster in that case. Hence, it is good design to avoid creating WITHOUT ROWID tables with single-column PRIMARY KEYs of type INTEGER.