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).