NUM_ROWS_PRODUCED_LIMIT Query Option
The NUM_ROWS_PRODUCED_LIMIT query option limits the number of rows produced by a query. A query is canceled when its execution produces more rows than the specified limit set by the NUM_ROWS_PRODUCED_LIMIT option.
This limit only applies when the results are returned to a client, for example, to a SELECT query, but not to an INSERT query.
The default value of 0 specifies that there is no limit on the number of rows produced.
Allowed values: 0 or positive numbers