On Wed, 12 Jan 2005 10:09:30 -0800 (PST), Jose Luis Delgado <joseluis_delgado@xxxxxxxxx> wrote: > All... > > We need to build web reports to display those data I > mean volumes and some parameters, for some reports the > type is as following: > > for a date: > today_volume, > volume_yesterday, > from_begin_month, > from_begin_year...... > > Please, note that this structure is asking for high > summaries as from the beginning of the year/month up > to date. Is this historical data that stays static after a particular day? If so, maybe borrowing a page from the datamart world would be in order. Would it be a problem to create aggregate data table(s)? Steven -- //www.freelists.org/webpage/oracle-l