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 Grant (privilege) Statement).