MySQL Forums
Forum List  »  Optimizer & Parser

Limiting query research to a specified n. of records
Posted by: marco rossi
Date: March 16, 2007 04:35AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Limiting query research to a specified n. of records
2938
March 16, 2007 04:35AM


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.