Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Nope, that's the way it works. REINDEX will simply tacks the new keys at the end of the CDX and not reuse the old space. This is called Index Bloat. You need to DELETE TAG or DELETE TAG ALL before doing and INDEX ON (At this point, REINDEX will not work). There is a KB article on my web site that explains this.
>
>Joe is saying that he's seeing the opposite behavior. In other words, the CDX file is 113MB after all the INSERTs. Then he does a REINDEX and the CDX file reduces in size to 65MB. FWIW, I think REINDEX does erase and rebuild the CDX (though I never use the command personally... I always do a DELETE TAG ALL and INDEX ON).
>
Thanks Brad...you crystallized my question perfectly.
Might have to give you a point for simply reading the actual post carefully, since that seems to be a lost art once in a while here on the UT...
Thanks,
JoeK
Précédent
Suivant
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