To validate the status of your materialized view (MV) refresh, run a DESCRIBE EXTENDED command and check the row corresponding to the "last refresh status type."

• RECOMPUTE indicates a full load execution was completed.
• NO_OPERATION means no operation was performed during the refresh.
• INCREMENTAL or ROW_BASED signifies that incremental processing was carried out