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
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Backup/Restore vs Reindex


At 12:17 PM 13/01/2004 +0000, you wrote:

>Hi
>
>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.

/heLen



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12ce28vet/M=243273.4326031.5516772.1261774/D=egroupweb/S=1705115386:HM/EXP=1074083573/A=1750744/R=0/*http://servedby.advertising.com/click/site=552006/bnum=1073997173391358> Click to learn more...
<http://us.adserver.yahoo.com/l?M=243273.4326031.5516772.1261774/D=egroupmail/S=:HM/A=1750744/rand=312277453>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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