Subject AW: [firebird-support] Backup/Restore vs Reindex
Author Marc Geldon
So this "ALTER INDEX <index> INACTIVE / ACTIVE" reorganise or rebuild the indexes? Is that correct?

-----Urspr√ľngliche Nachricht-----
Von: Helen Borrie [mailto:helebor@...]
Gesendet: Dienstag, 13. Januar 2004 13:33
Betreff: Re: [firebird-support] Backup/Restore vs Reindex

At 12:17 PM 13/01/2004 +0000, you wrote:
>I read that there is a performance gain when you backup/restore your
>database regularly. A time ago my database was extremely slow and I
>reindexed it. It worked perfectly.
>I was wondering whether there are some other reason why
>backup/restore are good (for performance that is)?
>And is there anything wrong with reindexing?

Nope, it's good housekeeping. You don't have to drop the indexes - just
use ALTER INDEX <index> INACTIVE and then ACTIVE.

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. Of course, a restore is a
really good cleanup because it rebuilds the database from scratch.


Yahoo! Groups Sponsor

<*> Click to learn more...


Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

[Non-text portions of this message have been removed]