Limiting Queries by Rows Returned

Set the value of the QUERY_ROWS_RETURNED_LIMIT option to prevent the optimizer from rejecting queries with large result sets.

The QUERY_ROWS_RETURNED_LIMIT option tells the query optimizer to reject queries that might otherwise consume too many resources. If the query optimizer estimates that the result set from a query will exceed the value of this option, it rejects the query with the message:

Query rejected because it exceed resource: Query_Rows_Returned_Limit

If you use this option, set it so that it only rejects queries that consume vast resources.