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
