CODEWITHSUNDEEP
sqloracle-databaseoracle11g
the_lotus
the_lotus

Reputation: 12748

Trying to find the right materialized view refresh options

I have a lot of historical tables and to help with the queries I created materialized view. Right now I do 

create materialized view ...
refresh force on demand

And have a job once a day that does

DBMS_MVIEW.REFRESH(..., 'C')

Is there a way for the materialized view to be updated dynamically without being to slow? The changes only adds to the materialized view, they never update or delete the data. I have a bit of trouble understanding all the refresh options.

Upvotes: 0

Views: 60

Answers (1)

pmdba
pmdba

Reputation: 7033

Use of fast refresh, with materialized view logs on the source tables, should work for you. It would allow you to only apply changes to the MV. Check out this article on MV options and architecture for more details: https://oracle-base.com/articles/misc/materialized-views

Upvotes: 1

Related Questions