Re: Does updating an index with the same data cost?

Posted in 1996

Peter Kolmhofer — Tue, 13 Aug 1996 15:48:47 +0200 — source: Informix-list mailing list archive (1991-1998)

Mike Johnson wrote: > > The title says it all really. If I update a row, including the index > key fields with the same data as they already have, is Informix (Online > 5.03) clever enough to see that the data is the same and not bother > updating the index? > > Mike. Hi Mike, I'd rather say: Your application should be clever enough to update only those columns that have actually changed :) Peter