Archive for August, 2013

Fast refresh of aggregate-only materialized views with MAX – algorithm

In this post I will illustrate the algorithm used by Oracle (in 11.2.0.3) to fast refresh a materialized view (MV) containing only the MAX aggregate function: create materialized view test_mv build immediate refresh fast on demand with rowid as select gby as mv_gby, count(*) as...
Read more

Fast refresh of aggregate-only materialized views with SUM – algorithm

In this post I will illustrate the algorithm used by Oracle (in 11.2.0.3) to fast refresh a materialized view (MV) containing only the SUM aggregate function: create materialized view test_mv build immediate refresh fast on demand with rowid as select gby as mv_gby, count(*) as...
Read more

Fast refresh of aggregate-only materialized views – introduction

This post introduces a series about the algorithm used by Oracle (in 11.2.0.3) to fast refresh a materialized view (MV) containing only an aggregate: create materialized view test_mv build immediate refresh fast on demand with rowid as select gby as mv_gby, count(*) as...
Read more