Re: dbms_refresh
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- Date: Wed, 13 Oct 2010 12:43:30 -0700
On Wed, Oct 13, 2010 at 10:59 AM, Chuck Boddy
<Chuck.Boddy@xxxxxxxxxxxxxxx>wrote:
> Hi Jared,
>
> I’ll try that…The materialized view in question is just a snapshot
> table..the trigger populates a table with aggregate values…pretty
> straightforward…
>
>
>
It would seem to make sense to have a nested MV for the aggregates, and skip
the trigger.
There may be a very good reason for it being done the way it is, but the
nested MV seems a simpler method.
Jared
Other related posts:
