4 ms·
That's what Oracle FAST REFRESH does as well, in the limited cases where it works. Which is why a comparison to Materialize would be intersting...
by rst 6y ago
That's what Oracle FAST REFRESH does as well, in the limited cases where it works. Which is why a comparison to Materialize would be intersting...
- arjunnarayan 6y agoI 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.