|
|
|
|
|
|
by sehrope
4222 days ago
|
|
|
Oracle supported both full refresh and incremental refresh as of at least 10 years ago (maybe longer). Fast refresh requires creating "MATERIALIZED VIEW LOGS" on the source table(s) and covers most (but not all) aggregations/groupings in the mview SQL. Once it's setup, DML to the source tables gets logged to the mview logs and a "fast" refresh of the mview uses it to incrementally update the mview's data. |
|
|