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

Due to Fragmentation, insure that the table has been created with "ROWID". Informix makes this available but it IS NOT RECOMMENDED!! See the Informix Guide to SQL "Reference" page 9-39 to 9-40. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 5 Jul 1996, Dave K. Lahoti wrote: > 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 >