>>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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.