Incremental refresh of materialized views over Cloud Links

With incremental refresh of materialized views over Cloud Links, the Autonomous AI Database refreshes only changed data from remote tables instead of recomputing the entire materialized view.

The MV_FAST_REFRESH parameter in the REGISTER and UPDATE_REGISTRATION procedures of the DBMS_CLOUD_LINK package enables providers to explicitly support fast refresh for cloud links. This fast refresh capability improves dashboard and report performance and provides real-time analytics.

For more details, see Optimize Cloud Links Performance with Materialized Views .