0

I have a materialized view that brings back 2 columns and roughly 300m rows.

The materialized view is based on joins between multiple views.

Currently it takes roughly 10 minutes for this to refresh and I am trying to improve the refresh time since there are usually very few changing records in this data set.

I currently run a "Complete" refresh - is there a way to run a fast refresh since this materialized view is based on other views and not tables?

Thank you

AAA
  • 2,388
  • 9
  • 32
  • 47

1 Answers1

2

See https://docs.oracle.com/database/121/DWHSG/basicmv.htm#i1007007 for fast refresh requirements and limitations.

Use DBMS_MVIEW.EXPLAIN_MVIEW for analyzing your materialized view query to see why the fast refresh is not possible to use.

Husqvik
  • 5,669
  • 1
  • 19
  • 29