Re: Reindex database

On Fri, 12 Dec 2003, Greg Spiegelberg wrote:

> Any rule of thumb for REINDEX DATABASE?  Once per month?
> Per x transactions?

You shouldn't need to reindex databases for the most part.  If there's
lots of catalog updates / delete, it might be occasionally useful to down
the database and reindex those catalogs in single user mode since you
can't reindex them on a live database if I remember correctly.

If you are running 7.3.5 or before, you might need to schedule daily /
weekly / monthly etc reindexes of indexes that show unreasonable growth
problems.  This should be mostly fixed for 7.4, and reindexes should not
really be needed anymore, we hope :-).

generally speaking, reindex is for fixing broken indexes, not generaly
maintenance.