I am planning to make a materialized view for a frequently used query which joins multiple tables and all these tables are huge
I am trying to understand the impact it may have on the system.
CREATE MATERIALIZED VIEW catalog
REFRESH FAST START WITH SYSDATE NEXT SYSDATE + 1/1440
WITH PRIMARY KEY
AS SELECT * FROM a, b, c, d ...;
As shown above (dummy query) this materialized view is being refreshed every 1 minute. Does this mean that every one minute the query in this view will be regenerated (optimized, parsed, fetched etc). This might prove to be a huge load on the system.
Please let me know what you think