Posted in 2006
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)?
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.