--- In ib-support@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:

> 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

I have noticed the same behaviour with other DB as well. Probably re-
reading all the rows to index renders that approach slower. Perhaps
in a locked file situation that might work?