String 

QUERY_REWRITE_INTEGRITY =

{ENFORCED | TRUSTED | STALE_TOLERATED} 

Dynamic. Scope = ALTER SESSION, ALTER SYSTEM. 

ENFORCED 

Multiple instances can have different values. 

QUERY_REWRITE_INTEGRITY determines the degree to which Oracle must enforce query rewriting. At the safest level, Oracle does not use query rewrite transformations that rely on unenforced relationships. 

• ENFORCED: Oracle enforces and guarantees consistency and integrity.

• TRUSTED: Oracle allows rewrites using relationships that have been declared, but that are not enforced by Oracle.

• STALE_TOLERATED: Oracle allows rewrites using unenforced relationships. Materialized views are eligible for rewrite even if they are known to be inconsistent with the underlying detail data.

See Also: Oracle8i Data Warehousing Guide for more information on query rewrite of materialized views.