Re: sql question

Posted in 1995

John Prideaux — 13 Oct 1995 12:56:03 GMT — source: Informix-list mailing list archive (1991-1998)

onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") wrote: >An enhancement to the suggestion made would be to use a SCROLL cursor and >then fetch absolute COUNT-50. Then you could fetch next the rest of the >records > [ much of previous discussion deleted ] I think that scroll cursors take a "snapshot" of the set of rows, so there will be substantial overhead if you are selecting a large number of rows. Other than that, it seems to be a very appropriate suggestion. John Prideaux alastl@ix.netcom.com