Question: how to change query in materialized view?
Answer: To change its storage characteristics. To change its refresh method, mode, or time. To alter its structure so that it is a different type of materialized view. To enable or disable query rewrite.