REINDEX is a command that I find almost useless. If there are any problems with the header of your tag, this command will only perpetuate them. Since the tag is kept up-to-date automatically, the only reason I know of to re-create the index is when there are problems, and REINDEX won't fix that.


Barbara,
it is true only if you uses structural CDX only,
or you open all not structural CDXs od IDXs every time.

If you update/insert the 90% of a large table,
it is much more faster
- to close the indices,
- to update the table,
- to reopen the indices
and to make REINDEX.

Fabio