3 ms·
Oracle will do - a couple of options, either a full rebuild or an incremental rebuild.
by 4ndrewl 1y ago
Oracle will do - a couple of options, either a full rebuild or an incremental rebuild.
- tanelpoder 1y agoAlso, latest Oracle version (23ai) has added "concurrent on-commit fast refresh" functionality, where concurrent transactions' changes are rolled up to the MV concurrently (previously these refreshes were serialized). https://oracle-base.com/articles/23/materialized-view-concurrent-refreshes-23 https://oracle-base.com/articles/23/materialized-view-concur... From the article: "Concurrent refreshes will only happen if there are no overlaps in the materialized view rows updated by each session."