Hi everyone,

I have a FPW2.A table with 5.7 meg records and I have to append about 40K records in one shot, once a week. I have seven indexes for the table which I only use to retrieve SELECTed data. The table seems optimized fairly well at this point since it typically takes less than one second to get the data.

The problem is it's taking around fifteen minutes to append the new records. It's the indexing that's taking the time.

The questions are:
1. Can this be sped up?
2. Is there a way to indicate that something is happening, like "Appending Records"; "Indexing Index##" and the like? Maybe a progress bar? Something instead of the non-informative hourglass.

Any advice and smart-alec comments appreciated.
TIA,
Pete