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
>