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.