CREATE MATERIALIZED VIEW [ IF NOT EXISTS ][ schema. ] materialized_view [ OF [ schema. ] object_type ] [ ( column_alias [ ENCRYPT [encryption_spec] ] [, annotations_clause | { scoped_table_ref_constraint | column_alias [ENCRYPT [encryption_spec]] } ]... ) ] [ DEFAULT COLLATION collation_name ] { ON PREBUILT TABLE [ { WITH | WITHOUT } REDUCED PRECISION ] | physical_properties materialized_view_props } [ USING INDEX [ physical_attributes_clause | TABLESPACE tablespace ]... | USING NO INDEX ] [ create_mv_refresh ] [ evaluation_edition_clause ] [ { ENABLE | DISABLE } ON QUERY COMPUTATION ] [ query_rewrite_clause ] [ { ENABLE | DISABLE } CONCURRENT REFRESH ] [ annotations_clause ] AS subquery