Altering a materialized view
Alter the properties of a materialized view with the ALTER MATERIALIZED VIEW command.
Materialized views are created with the default table properties. Use the
ALTER MATERIALIZED VIEW
command to alter the view's properties.
Specify updated properties and values in a WITH
clause.
Materialized views do not perform repair, so properties regarding repair are
invalid.
Procedure
Alter a materialized view to change the caching properties.
ALTER MATERIALIZED VIEW cycling.cyclist_by_birthday
WITH caching = {'keys' : 'NONE', 'rows_per_partition' : '15' };