Limiting query research to a specified n. of records
Is there a way to limit a query so that it finds only a specified n. of records, and then stops when the rquested records have been found?
I know the LIMIT clause, but it acts only on visualization: the query is executed completely, but only part of the results are showed. Am I wrong?
I'd like to know a way to interrupt the query when the n. of records has been found, in order to minimize the time requested to run the query.
Subject
Views
Written By
Posted
Limiting query research to a specified n. of records
2972
March 16, 2007 04:35AM
2097
March 16, 2007 09:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.