Hacker News new | ask | show | jobs
by 4ndrewl 297 days ago
Oracle will do - a couple of options, either a full rebuild or an incremental rebuild.
1 comments
tanelpoder 297 days ago
Also, 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-concur...

From the article: "Concurrent refreshes will only happen if there are no overlaps in the materialized view rows updated by each session."

link