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

: 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? Yes, Informix-OnLine is clever enough not to update the index. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Oakland ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.