Materialized View Sub-Query Enhancements
(Doc ID 149112.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
This article is intended to introduce enhancements in Oracle9i and above, which broaden
fast refresh capabilities with sub-queries in materialized views.
This article assumes the reader has an understanding of materialized views/
snapshots introduced in previous versions. The enhancements discussed in this
document are intended to lessen the restrictions on performing a fast refresh
in Oracle9i and above.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!