>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).

--Brad