SQLite Forum

Defragment a table ?
There is a difference between "building as you go" and re-organizing the index.  Emptying the table and refilling it will result in the same non-optimally packed index as existed before (in that the data was not loaded in-order as happens when you do a create index or a reindex).