Používáte Flexviews (materialized views)?

A "regular" view is a virtual table representing the result of a database query. A materialized view is like a regular view, except that the results are stored into an actual database table, not a virtual one.

Flexviews supports two different refresh methods: COMPLETE and INCREMENTAL. You specify the refresh method when you create the view. An incremental refresh will only read data based on the row values which have changed since the last delta computation. This is much more efficient, and can be orders of magnitude faster than a complete refresh.