UPDATE performance ( Informix specific )

Posted in 1993

Bob Maccione — Thu, 2 Dec 1993 08:36:11 — source: Informix-list mailing list archive (1991-1998)

When doing an update to a row in a table ( update current ), is Informix smart enough to compare the index members to see if they have changed from the original value or does it blindly update all of the indexes? This question is directed towards 4.1 and the 5's. Thanks in advance, bob maccione bmaccion@promus.com ps: Hi Naomi, it's raining again...