Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Initialization Parameters, 170 of 222
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.
Values:
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.
|
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|