Notes

Refresh use of materialized query tables: No materialized query tables are used to evaluate the select-statement during the processing of REFRESH TABLE statement.

Refresh isolation level: The isolation level used to evaluate the select-statement is either:

Number of rows: After successful execution of a REFRESH TABLE statement, the ROW_COUNT statement information item in the SQL Diagnostics Area (or SQLERRD(3) in the SQLCA) will contain the number of rows inserted into the materialized query table.