On 3/16/15, Simon Slavin <slavins at bigfraud.org> wrote: > > Because of the format in which SQLite keeps its indexes, you > cannot always repair a corrupted index by deleting the rows which you think > are corrupt. Sometimes you need to delete other rows too (for example those > immediately before and after a corrupt row) and you need detailed analysis > of what's wrong with the index to know exactly what you need to delete.
But you can always repair corruption in indexes using the "REINDEX" command. -- D. Richard Hipp drh at sqlite.org