Updated on 2025-05-29 GMT+08:00

Overview

Complete-refresh materialized view is a materialized view that supports only complete refresh. That is, old data is discarded and the entire table is recalculated for query.

The syntax for creating a complete-refresh materialized view is similar to that for CREATE TABLE AS. For details, see "SQL Reference > SQL Syntax > CREATE TABLE AS" in Developer Guide.