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.