Subject RE: [ib-support] Massive INSERT test
Author Alan McDonald
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
I still do it though... spose I hope that the pure logic is true even though
my test showed otherwise


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