Re: sum table

ohahaahr_at_hotmail.com wrote:
> Unfortunately the result of my query must be "updated" at all times. So
> therefore a nightly refresh of the materialized view will not do.

And what does that have to do with materialized views? Materialized views can be as current as you wish. The question is where you want to take the pain ... in creating the MV (once) or in your queries (many times).

> Regards,
> Ole

Read the concepts books at http://tahiti.oracle.com.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)