> Problem:
> I'm executing a select statement over joined tables. As a
> result I get 10
> 000 records.
> But I only want to get the record's 20-31 (for example).
> This is a typical function of search-engines.
Most of the programming interfaces have a method to move
to a specific record in the result set. The rows skipped are
not copied to the client. If you stop reading rows after row 31,
then the remaining rows are also not copied to the client (except
for a few which are already copied to the client).
This will not solve all your problems as the database might
still create a temporary result set of all the 10000 records.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmar@stripped
http://www.sapdb.org/
