Re: sql question

> 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 ] > John Prideaux replied:- > I think that scroll cursors take a "snapshot" of the set of rows, so > therewill 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 Malcolm Weallans would like to add the following suggestion. Use of KEY-ONLY Select technique will save the requirement to take a snapshot of all of the rows. The technique involves using a cursor to get a snapshot of the keys which match the query and using a subsequent query to get the individual rows. This would be advantageous in most situations. I keep forgetting that many of the poeple in this conference are not aware of this invaluable technique. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc