version 9i
Problem is, there's a lot of code already written, and originally I was
thinking of making a materialized view and rewrite the code to use the
MV instead of the tables. But I was wondering how flexible or smart is
the query rewrite thing so maybe I don't have to change the code or not
all of it...
Like, how would it work if I had this:
table1: a,b,c,d,e
MView: select a,sum(b) x,sum(c) y,max(d) z from table1
query: select a-4, sum(b)+sum(c),max(d) from table1 where e=10
Will Oracle use MView here?
Received on Tue Jan 11 2005 - 08:17:13 CST
