oracle including new values,物化视图日志加不加INCLUDING NEW VALUES有什么影响

满意答案

ap.jil

2016.06.30

采纳率：58%    等级：9

已帮助：213人

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.

00分享举报

总结

以上是生活随笔为你收集整理的oracle including new values,物化视图日志加不加INCLUDING NEW VALUES有什么影响的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。