Indexes

[Kenneth Brody]

On 3/8/2011 3:33 PM, Richard Kreiss wrote:
> We all know that one can't create an automatic index while a file is being
> used.
>
> What, if any, would be the effect of creating a new index in a copy of the
> file, and then copying the new index back into the original directory.

It would immediately become corrupt as records were added/deleted/modified, 
since anyone already in the file will not be updating that index.

[...]
> I would surmise that the index would not be seeing by any programs which
> accessed this file until the next time they were loaded.
>
> Am I correct in my thinking?

Correct.

-- 
Kenneth Brody