- Posted by Gavin Soorma
- On December 26, 2017
- 3 Comments
One of the new features in Oracle 12c Release 2 is real-time refreshable Materialized Views.
In earlier releases, even if a single row in the base table got changed, the underlying materialized view was marked as stale and this prevented any query rewrite operations until the materialized view