>>>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.