Category: SQL

join_methods

Understanding Join Methods In Oracle Database 19c

A join method is the mechanism for joining two row sources. Depending on the statistics, the optimizer chooses the method…

deterministic_result_cache

Understanding Clustering In Oracle Database

Clustering is a method of storing tables that are intimately related and often joined together into the same area on…

log4plsql_prc_fnc

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…