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

Home -> Community -> Usenet -> c.d.o.misc -> Re: sum table

Re: sum table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 31 Aug 2005 08:08:57 -0700
Message-ID: <1125500937.506577.44270@g44g2000cwa.googlegroups.com> 





Ole, yes I think a materialized with query rewrite enabled may well be
useful to you especially if you can limit the query results to only
being through the end of business on the previous day.  Then you could
refresh the materialized view just once daily.



HTH -- Mark D Powell --
Received on Wed Aug 31 2005 - 10:08:57 CDT












Original text of this message













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