[NO]MAXROW
The SET MAXROW statement restricts the estimated number of rows that can be returned by subsequent queries. Value must be less than or equal to the session's value for query_row_limit. If no query_row_limit is set, there is no limit on the number of rows returned.
When MAXROW is set, it remains in effect until another SET MAXROW or SET NOMAXROW statement is issued, or the session terminates.
Note: MAXROW does not impact update, insert, deletion or other queries that do not return rows of data to the user.
For more information, see query_row_limit in the description of
GRANT (privilege).
Last modified date: 04/26/2024