Re: materialized view for this?

I strongly recommend reading the documentation.

Again, in this case rewrite *could* not possibly work because "e" does not exist in your materialized view. In theory rewrite would occur if your materialized view was defined as....

select a, e, sum(b) x,sum(c) y,max(d) z from table1 group by a, e

There are more limitations on max than there is on sum, that is why it is important to read the doc. Also, there are certain requirements like including count(*) and/or avg(colX) in your materalized view even if you don't need them in order to get certain rewrites to work.

Then try some simple tests (e.g., table, materialized view, query, explain plan) to see if rewrite is actually happening.

Dave Received on Tue Jan 11 2005 - 08:32:51 CST