Category: SQL
- SQL
- May 18, 2022
Understanding RealTime Materialized View In Oracle Database 19c
In earlier Oracle version, QUERY REWRITE feature used to stop working as soon as the materialized view become STALE, unless…
- SQL
- July 4, 2021
Understanding Materialized View Query Rewrite
When base tables contain large amount of data, it is expensive and time-consuming to compute the required aggregates or to…