>>>>Thanks Borislav, that's it.
>>>>The decision to use non-production indexes was made before my time...
>>>>I think one reason was to speed up appends by disabling indexing.
>>>
>>>:) Adding 10 records and reindexing 100,000 is no savings. :)
>>>
>>>Of course since there's a UDF in the index, that could make things slow enough to warrant such a tactic. ;)
>>
>>But, but, You need to reindex them anyway :-)
>
>Adding 10 records to an existing table with indexes does not require a reindex. The new records' keys are inserted without a complete rebuild.

But what happens if the INDEX is not open?
I remember my nightmares when I worked with CLIPPER, If you forgot to open an INDEX when you update key fields then.... (don't want to remember what happened then :o)))))