Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement