8. SQL Statements : SET : [No]Maxpage
 
Share this page                  
[No]Maxpage
The SET MAXPAGE statement restricts the maximum number of pages per query on the database. The value must be less than or equal to the session's value for query_page_limit. If no query_page_limit is set, there is no limit on max page usage per query.
When MAXPAGE is set, it remains in effect until another SET MAXPAGE or SET NOMAXPAGE statement is issued or the session terminates.
To set query_page_limit for a user, use the GRANT statement. For more information, see Grant (privilege) (see page GRANT (privilege)).