I did some tests doing this sometime ago... it took longer to add the index
at the end of the process than it did to leave it on while the inserts were
going.
I still do it though... spose I hope that the pure logic is true even though
my test showed otherwise

Alan

How selective are your indexes? I.e. will there be lots of duplicates? If
you were doing an insert like this, I would assume your best bet would be
to turn off the indexes during the insert and then turn them back on
afterwards.