物化视图日志加不加INCLUDING NEW VALUES有什么影响

lusklusklusk · 发表于 2016-1-28 16:26

创建物化视图日志语句如下
CREATE MATERIALIZED VIEW LOG ON tablename WITH PRIMARY KEY INCLUDING NEW VALUES;

一开始理解成：不加的话，主表执行update后，物化视图不会刷新。后来实验了以下，主表执行insert、update、delete后物化视图都会刷新

理解不了，加不加INCLUDING NEW VALUES具体有什么影响
INCLUDING NEW VALUES clause lets you specify whether Oracle Database saves both old and new values for update DML operations in the materialized view log. The value you set in this clause applies to all columns in the log, not only to columns you may have added in this ALTER MATERIALIZED VIEW LOG statement.

lusklusklusk · 发表于 2016-2-4 09:51

自己顶一下

jieyancai · 发表于 2016-2-4 10:55

NEW VALUES Clause

The NEW VALUES clause lets you determine whether Oracle Database saves both old and new values for update DML operations in the materialized view log.

See Also:
"Including New Values in Materialized View Logs: Example"
INCLUDING
Specify INCLUDING to save both new and old values in the log. If this log is for a table on which you have a single-table materialized aggregate view, and if you want the materialized view to be eligible for fast refresh, then you must specify INCLUDING.

http://docs.oracle.com/cd/E11882 ... s_6003.htm#i2119924

bluemoon0083 · 发表于 2016-2-4 11:29

其实具体有什么影响你贴的英文已经说明了，估计你是不明白这么做了之后有什么用途或目的

你可以看下文档，主要是用于不同目的的MV的，比如下面这个：
Restrictions on Fast Refresh on Materialized Views with Aggregates

■ All tables in the materialized view must have materialized view logs, and the
materialized view logs must:

Specify with ROWID and INCLUDING NEW VALUES

比如这个，都没有提到，INCLUDING NEW VALUES有没有都无所谓：
Restrictions on Fast Refresh on Materialized Views with Joins Only

再结合说明saves both old and new values for update DML operations in the materialized view log，自然就能想明白了

lusklusklusk · 发表于 2016-2-4 11:37

bluemoon0083 发表于 2016-2-4 11:29
其实具体有什么影响你贴的英文已经说明了，估计你是不明白这么做了之后有什么用途或目的

你可以看下文档 ...

多谢

lusklusklusk · 发表于 2016-2-4 11:42

jieyancai 发表于 2016-2-4 10:55
NEW VALUES Clause

The NEW VALUES clause lets you determine whether Oracle Database saves both old ...

多谢
If this log is for a table on which you have a single-table materialized aggregate view, and if you want the materialized view to be eligible for fast refresh, then you must specify INCLUDING.