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

Posted in 1996

Jay Aymond — Fri, 20 Dec 1996 14:33:15 GMT — 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 because the index does not have to be re-read. *************************************************************** Jay Aymond United Companies Life Insurance Company Email: jay@ulife.com ***************************************************************