What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
- 1 Answers
- 728 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
