I think a 5-second summary of the difference is that Materialize is Oracle FAST REFRESH for almost* all of SQL, as opposed to just those very limited cases wher

I think a 5-second summary of the difference is that Materialize is Oracle FAST REFRESH for almost* all of SQL, as opposed to just those very limited cases where Oracle's FAST REFRESH works. Oracle's docs have entire features in order to help you diagnose whether your views are eligible for fast or synchronous refresh[1]. In Materialize, everything you can express in SQL is fast refreshed. No caveats. [1] https://docs.oracle.com/database/121/DWHSG/sync.htm#DWHSG9146 https://docs.oracle.com/database/121/DWHSG/sync.htm#DWHSG914... *Almost, because the surface area is truly astonishing.