Hi Viv,

>FWIW, we've generally found it's faster to actually delete all non-required indexes before appending a large number of records then recreating them afterwards. Can't do that with a 'live' database of course...
>
A solid technique, but the numbers are in this case stacked against it:
for between 0 and 1000 batched appends I am sure it won't be
faster to reindex a million records.

regards

thomas