Query_rewrite _ integrity settings

Query_rewrite _ integrity settings. The query_rewrite_integrity parameter has three values:
Stale_tolerated indicates that the materialized view is still used even if the data in the detail table has changed.
Trusted indicates that the materialized view is used only when it is invalid. However, you can use trust relationships for query rewriting, such as those declared by dimension objects or constraints that have not yet taken effect.
Enforced (default) indicates that the materialized view is used only when the same result as the detail table is provided. Using this parameter means that invalid materialized views or trust relationships are not used for query rewriting.
The correct settings depend on the data requirements of the application. If the invalid materialized view is used for query rewriting, different results may be generated when the query rewriting is not used. However, if detailed data is used, the performance may deteriorate due to the large amount of data to be processed in the response query. In a data warehouse, the trusted full level is usually used, because this ensures that you only use materialized views with the latest data; however, it is declared as correct (trustworthy) can also be used to query and rewrite. In most data warehouses, these relationships have been validated in the extract, transform, and load (ETL) process, so verification is no longer required.