Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Limit a query

Limit a query

From: watscheck <watscheck_at_yahoo.de>
Date: 14 Aug 2002 03:19:05 -0700
Message-ID: <679d8c30.0208140219.79dc9aac@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 - 05:19:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US