Hello Arno,

>> What about a unique index? In the original post Alexandre says that
>> PK stays active while he perform a bulk insert... Should he recompute
>> the statistics during the bulk insert? Could it improve the insert
>> performance?

AB> Indexes controled by a constraint (PK/FK/U) cannot be
AB> disabled thus will stay active.
Yes, I know about that. I meant that one could drop/recreate a
constraint if needed during a bulk inserting.

AB> For inserts no indexes are used, so i don't see how this
AB> could improve insert performance or i misunderstood your
AB> question?
I suppose, inserting adds new nodes to an index, and that takes server
resources - I mean that point of view. But now I see that it has
nothing to do with an index selectivity. Thanks.


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com