SQLite Forum

Defragment a table ?
Login
> A without rowid table isn't going to help things if the primary key is already an integer

I disagree with that statement. But the OP can find out for him/herself,  
if s/he wants to :).  I have no time to investigate myself ATM.