最初由 zhxx_ora 发布
[B]TRUSTED, 将使用明确声明的关系来允许重写。 [/B]
------------------------------------------------------------------
# ENFORCED
Oracle enforces and guarantees consistency and integrity.
# TRUSTED
Oracle allows rewrites relationships that have been declared[/COLOR] , 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.
----------------------------------------------------------------
ENFORCED是强制当ORACLE确定视图和基表的数据一致的时候才允许QUERY REWRITE
STALE_TOLERATED是始终允许QUERY REWRITE 不论数据是否一致
TRUSTED的解释中红色的部分具体是什么意思? 不理解, 刚才的兄台翻译过来我看着也糊涂.