关于QUERY_REWRITE_INTEGRITY的疑问

[复制链接]
查看11 | 回复1 | 2005-10-27 20:45:16 | 显示全部楼层 |阅读模式
关于QUERY_REWRITE_INTEGRITY的疑问
?QUERY_REWRITE_INTEGRITY: This parameter can also be reset dynamically for the instance and for an individual session. It accepts the following values:
-Enforced (the default): Enables query rewrites only if the server can guarantee consistency. Only up-to-date materialized views and enabled validated constraints are used for query rewrites.
-Trusted: Allows query rewrites based on declared, but not necessarily enforced, relationships. All updated materialized views and constraints with the Rely flag are used for query rewrites.
-Stale_tolerated: Allows query rewrites to use materialized views that have not been refreshed since the last declared DML operation and relationships.
Enforced:只有在server可以保证一致性的时候,才允许query rewrite使用MV。
Stale_tolerated:从字面上就可以看出,即使是陈旧的MV,也允许query rewrite使用。
但这个Trusted大概是个什么意思呢,实在是翻译不好,请各位帮助,谢谢
回复

使用道具 举报

千问 | 2005-10-27 20:45:16 | 显示全部楼层
呵呵,各位帮助一下啊,先给大家拜年了:)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行