Index maintenance

[Kenneth Brody]

On 12/19/2011 12:09 PM, Ian Wood wrote:
> On Mon, Dec 19, 2011 at 11:59 AM, Kenneth Brody<kenbrody at spamcop.net>wrote:
>
>> On 12/19/2011 11:37 AM, Ian Wood wrote:
>>> I am having an issue almost daily where a file is getting bad automatic
>> indexes.
[...]
>>> filePro version is 5.014DN9
>>>
>>> When looking at the index through dxmaint it says Invalid Index. I have
>> to delete the index and then rebuild it manually.
>>
>> The bigger problem is what's causing the indexes to become invalid.
[...]
>> But, as I said, the bigger issue is tracking down what's causing the
>> indexes to become invalid.
[...]
> I just read Rich's response about an unprotected lookup, this is certainly
> possible and I can certainly scan all my processing tables for this.

While modifying unprotected lookups can corrupt indexes, they won't go 
"invalid".  (That is, they will contain incorrect information, but filePro 
still sees them as "valid" indexes, and dxmaint's "-ra" will still work.)

-- 
Kenneth Brody