Give An Example Of An Expression Defining A Materialized View

Give an example of an expression defining a materialized view and two situations (sets of statistics for the input relations and the differentials) such that incremental view maintenance is better than recomputation in one situation and recomputation is better in the other situation.

Posted in Uncategorized