Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> materialized view for this?

materialized view for this?

From: <wolfing1_at_yahoo.com>
Date: 10 Jan 2005 12:36:02 -0800
Message-ID: <1105389362.861096.148480@f14g2000cwb.googlegroups.com>


Hello.
I'm trying to speed up some queries that just take too long to run in our applications.
I have a big historical table of the form: Table A:
day date,

amt1 number,
amt2 number,
amt3 number,

other1 varchar2,
other2 varchar2

so I was wondering if I should create a materialized view like this: select trunc(day),sum(amt1),sum(amt2),sum(amt3),max(other1) from A

Would the query rewrite feature know how to rewrite a statement like this:
select trunc(day)-4,sum(amt1) from A where other1='test' ? Received on Mon Jan 10 2005 - 14:36:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US