Re: Let me be the first
Posted in 2006
Lukas Barton — — source: Usenet: comp.databases.informix
Obnoxio The Clown wrote: > Lukas Barton said: > >> scottishpoet wrote: >> >>> update locks.. >>> >>> 1 lock required for an update on the row >>> >>> 2 required on the key if you are updating the key >>> >>> so you are updating the key? >>> >>> >> Yep. I update indexed column. >> > > At the risk of causing even more offence, I believe that to be very poor > application design. > You mean that updating indexed column is poor design? You don't use indexed fields to hold some value (incl. foreing keys)?