Re: Delete Cursor: What To Use In Select Clause?

Posted in 1996

Dave K. Lahoti — Fri, 05 Jul 1996 10:33:12 -0700 — source: Informix-list mailing list archive (1991-1998)

I believe that a 'SELECT rowid FROM . . .' is the most efficient form. I believe this still stands true of engine versions 6 +. > >I am using a SELECT ... FOR UPDATE cursor to perform DELETE ... WHERE > >CURRENT statements. > > >Since I am not interested in the contents of the records I am deleting, I > >don't really need anything in the select clause of the SELECT