Skip to main content

CREATE MATERIALIZED VIEW

Use the CREATE MATERIALIZED VIEW command to create a materialized view. A materialized view can be created based on tables, materialized views, or indexes.

Syntax

CREATE MATERIALIZED VIEW mv_name AS select_query;

Parameters

Parameter or clauseDescription
mv_nameThe name of the materialized view to be created.
select_queryA SELECT query that retrieves data for the materialized view. See SELECT for the syntax and examples of the SELECT command.

Help us make this doc better!