Re: lock allocation

Just to add that you can check this easily with "onstat -k". Check the output (you may filter it by owner) Regards. On Wed, May 4, 2011 at 4:16 PM, Fernando Nunes <domusonline@gmail.com>wrote: > Yes. Indexes and I believe VARCHAR columns will consume more locks. > Regards. > > > > On Wed, May 4, 2011 at 3:26 PM, Tom Lehr <tomcaml@gmail.com> wrote: > >> i am running a dummy update to remove an in place alter. >> >> update t_contact set first_name=first_name where 1=1;>> >> i am curious for this table which is less than one million rows why >> the engine would dynamically allocate 2 million locks. the first >> million make sense to me but why more locks than rows in the tables? >> is it due to indexes? >> >> thanks >> tom >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...