Re: Slow inserts

Ben Thompson wrote: > To add more information, the BTREE scanner is going like mad when this > occurs. I didn't know the "onstat" for this one but Informix Server > Administrator can be very handy... So it looks like Art was right. Just to add more information in case anyone is interested, it seems that one way of solving it is to change the FILLFACTOR on the index to reduce BTREE scanner activity. The trade off seems to be that selects may be slower but inserts and deletes should speed up. Ben.