What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
- 1 Answers
- 729 Views
- I also Faced
- E-Mail Answers
Answer / Swamjeet Singh
A 'fast refresh' updates only the changed blocks of data in a materialized view, making it more efficient for smaller amounts of changes. A 'complete refresh', on the other hand, rebuilds the entire materialized view from scratch. Fast refresh is preferable when the data volume is small and changes infrequently, while complete refresh may be necessary if there are significant updates to the source data.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you find your id on a system?
What are dba privileges?
What skills does a dba need?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
Which function is used to find the largest integer less than or equal to aspecific value?
What are the different types of backup available in the oracle?
I am getting error "no communication channel" after changing the domain name? What is the solution?
What is the full form of dba?
What is the difference between internal & external schema?
What is the dba role in oracle?
What is the meaning of database backup?
What is da in database?
Oracle General 
