>>I have a process that has worked fine for over
>>a year. Today the system is locking up and I'm
>>not sure why.
>>
>>I suspect that it may be the result of a corrupted
>>index tag. Is there a way to tell if an index tag is
>>indeed corrupted? Is there a rule of thumb as
>>to how often the rebuild should take place?
>>I've also heard that I should not simply do a
>>REINDEX but that it should be a DELETE TAGS ALL
>>and then create the indexes. Is there an automated
>>way to do this?
>
>
>I would reindex whenever possible - on a set schedule. The way to recreate indexes is to...
>SELECT YourDataBase EXCL
>DELETE TAG ALL
>PACK
>INDEX ON tagname TAG tagname ADDITIVE
>INDEX ON tagname2 TAG tagname2 ADDITIVE
>INDEX ON tagname3 TAG tagname3 ADDITIVE
>USE
>
>HTH
>Wayne
Be careful with this one.
If you are using RI, dropping the index and rebuilding it also removes the RI, which you must then put back with code.
take care.
I don't use Stonefield yet but it is always mentioned as a solution to these things. As yet I have not had time to try how it handles the RI stuff.
HTH