Category: SQL

RealTime Mview

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…

mv_query_rewrite

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…