@Richard, I didn't know sqlite has a "REINDEX" statement - I used "drop index" and "create index" pair instead. Very helpful, thanks!
@Simon, No, you didn't waste my time, as I said above, I wonder if Richard would have mentioned the "REINDEX" command to me if you hadn't commented :) Thank you guys! On Wed, Mar 1, 2017 at 9:52 PM, Richard Hipp <[email protected]> wrote: > On 3/1/17, Simon Slavin <[email protected]> wrote: > > > > If you have a case where VACUUM does not fix a faulty index, that would > be > > very interesting. > > Not necessarily. VACUUM does not recreate the indexes, it just copies > them, row by row. So if the index is self-consistent but it does not > match its table (it has extra rows and/or is missing rows) then VACUUM > won't fix it. > > REINDEX does rebuild the indexes from scratch. If the problem is just > indexes that are missing entries or have extra entries, REINDEX will > fix it. > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Best Regards, Edwin Yip _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
