8. SQL Statements : SET : [No]Maxio
 
Share this page                  
[No]Maxio
The SET MAXIO statement restricts the estimated number of I/O operations that can be used by each subsequent query to the value specified. Value must be less than or equal to the session's value for query_io_limit. If no query_io_limit is set, there is no limit on the amount of I/O performed
When MAXIO is set, it remains in effect until another SET MAXIO or SET NOMAXIO statement is issued or the session terminates.
To set query_io_limit for a user, use the GRANT statement. For more information, see Grant (privilege) (see page GRANT (privilege)).