August 23rd, 2013 by Alberto Dell'Era
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 morePosted in materialized views | No comments
August 19th, 2013 by Alberto Dell'Era
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 morePosted in materialized views | 2 comments
August 5th, 2013 by Alberto Dell'Era
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 morePosted in materialized views | 4 comments
April 29th, 2013 by Alberto Dell'Era
In this post, we are going to complete part 1 illustrating the (considerably more complex) general case of a fast refresh from a master inner table without a unique constraint on the joined column(s). To recap, now the outer slice can be composed of more than one row, for example: ooo inn1 ooo...
Read morePosted in materialized views | No comments
April 22nd, 2013 by Alberto Dell'Era
In this series of posts we will discuss how Oracle refreshes materialized views (MV) containing only OUTER joins, covering only 11.2.0.3. We will use the very same scenario (MV log configuration, DML type, etc) as in the inner join case, “just” turning the inner join into an outer...
Read morePosted in materialized views | 2 comments