Identity Governance supports materialized view. Materialized view is a snapshot or an instance of time which is used to optimize performance in large scale reviews. If this view is enabled using the global configuration setting iac.review.display.materializedViews.enabled, you can cache user, account, permission, and role names to improve rendering time of review items by selecting Monitor Reviews > Cache review item names in a review definition. The search and sort features will use the values at the time the materialized view was either created or last refreshed.
NOTE:For small scale reviews, caching of review item names is NOT recommended.
As by definition, a materialized view is a snapshot, the data can become stale and out of sync with the catalog, and your search might not yield accurate results. You can refresh the snapshot data at any time by viewing the review definition of a review instance, and clicking Refresh. In addition, you can Enable or Disable the caching of review item names for that review instance.
NOTE:If materialized view is not initially enabled using the global configuration utility, Cache review item names check box will not be displayed.