Re: Is it faster if I use UPDATE WHERE CUURENT OF clause

Posted in 1996

Bret Lowry — Thu, 19 Dec 1996 20:51:27 -0500 — source: Informix-list mailing list archive (1991-1998)

Appala.Naidu@KSNCABP03.SNSGATE.sprint.com wrote: > > > > Hi, > If I declare a cursor <cname> for update and > subsequently use update WHERE CURRENT OF <cname>, > will I get a much improvement in performance ? > Or is it only guarantees a lock ? > > Thanks in advance for your input. Please respond to the > following address as I don't get this Informix bulletin > everyday. > > Appala.Naidu@nsc.sprint.com > > Thanks Yes, it is faster. Informix already "knows" where to update the row, it doesn't have to traverse and index tree. Also, if you prepare your updates and execute them you will get better performance as well:-) Bret.