Friday, March 03, 2017

Oracle 12cR2: Real-Time Materialized Views

Oracle 12cR2 is available for download - woohoo! One feature I'm excited about is the real-time materialized view, which allows a stale MV to be used by query rewrite. It sort of applies the changes from the underlying tables in real time. I was going to write up a demonstration of the feature, but a fellow named Uwe Hesse has already provided a very nice one on his blog. Check it out!

About Me

DBA/Developer working with a slew of databases, but most passionate about Oracle and Postgres. Big proponent of maximizing your database investment by taking advantage of the powerful features it has to offer. Big opponent of using your database as a generic, lowest common denominator bit bucket.