Subject Re: [firebird-support] Backup/Restore vs Reindex
Author Ivan Prenosil
> From: "Helen Borrie"
> gbak does other important housekeeping tasks, especially in cleaning out
> obsolete record versions and freeing up space occupied by the "stumps" of
> deleted rows. It doesn't housekeep indexes.

If you are talking about backup (not restore), than those tasks (cleaning
old versions) are just side effects caused by gbak reading all tables.
The drawback of this method is that it does not move stuck OIT,
and that you are not sure that the cleaning will finish at all since
garbage collect thread will stop when all users disconnects.
Sweep is much better tool for housekeeping.

Ivan
http://www.volny.cz/iprenosil/interbase/