Just only retrieve what rows you want. Oracle does not get the entire
result set it gets the result set as you ask for it.
Jim
"watscheck" <watscheck_at_yahoo.de> wrote in message
news:679d8c30.0208140219.79dc9aac_at_posting.google.com...
> Hello,
>
> I want to know if there is a way to limit the actual query, so that
> oracle stops to go on searching for further records.
>
> I know that there is a way to reduce the ResultSet by adding < ROWNUM
> or using setMaxRows (in JDBC) but this wont reduce the work of the
> dbms.
>
> Thank you,
>
> watscheck.
Received on Wed Aug 14 2002 - 10:08:08 CDT
