0

I want to update materialized view every 5 min such that it does a delta update not a full update. Can i use last modified date, and just update data that has been updated? my question is:

1) how to do update every 5 minute?

2) how to do just a delta import(update) so that it only updates the modified stuff and not go into the whole database.

Thanks.

Improve this question

1 Answer 1

Reset to default
2

What you're looking for here is a scheduled fast refresh, which requires a materialised view log on the master tables and which is subject to certain conditions (described in the documentation).

Whether your MV is suitable for this or not depends on the query that defines it.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.