Re: Help ! How to improve performance of a insert statement

One way is to remove indexes on the table involved. It's particularly interesting to remove indexes if the column(s) ivolved have many equal values. If you have such indexes it may also be an option to add another column to them to make each value more unique. Tuning of the DB engine for better write performance may of course also help. "ram" <rram@banbino.com> wrote: :Hi, : What are the ways we can improve performance of an insert statement. :Any pointers is appreciated. : :Thanks :Ramesh Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org