Re: Managing high volumes of data... how to...

when you use snapshots or materialized views, oracle does a truncate and insert append. if you have indexes on those materialized views, they remain. it is much slower to do bulk inserts with indexes and constraints.

its faster to drop the indexes, refresh, and then add them in parallel(not the parallel clause, create them all at the same time with nologging). In these types of cases i prefer the flexibility of 'create table as no logging' over materialized views.

• Original message --------------

> 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......

--
http://www.freelists.org/webpage/oracle-l