The process finished in 6206 sec. or ~2h. No errors this time.
>>>Well, are you postive that you're doing this with new set of indexes? Maybe you should make sure that SDT has gone through the recreation of indexes first, before trying anything else.
>>
>>I used our utility to Reindex few times. I also tried Repair option. In addition I tried to pack few tables (we have ~200 tables in a database).
>
>The difference between reindex and rebuild of indexes is that the latter doesn't even try to read the tag information from the existing .cdx (and/or .idx) files, because the tag headers may also be damaged. A rebuilder routine keeps that information elsewhere (mine keeps them hardcoded in a generated routine), destroys the cdx files and builds them from scratch.
>
>With a reindex, there's a chance that some of the tag headers may be just sufficiently damaged to cause problems, and still not damaged enough so the reindex proceed - with unpredictable results. The chances for this are very slim, of course, but you seem to be the statistical anomaly... how many times was it that you were hit by a problem nobody else has ever had?
>
>Mmmm... wasn't there a story from Arkadiy and Boris Strugatsky about a man who was a statistical anomaly?
If it's not broken, fix it until it is.
My Blog