Re: Index/Lock problem

Does The Table is Fragmented or Not? If Not fragment it , Also think of fragmenting the indexes.have an attached index which separates data pages from index pages. With proper fragmentation mechanism we can distribute data parallel to a table from different processes without page lock problem Thanks BALA bala.peddi@fmr.com David Sherrick wrote: > > I am having a problem with locks when an index exists on a table. It > appears that when a new row is inserted into a table that has an index > defined, the index page that was modifed is exclusively locked. This > prevents other processes from insert data into the same table until > the first process has committed or rolledback. By the way, this is > regardless of the isolation level set ( I tested this using dirty > read). > > I have talked with Informix technical support and they have confirmed > this.