Oracle普通视图和物化视图的区别

普通视图和物化视图的区别

https://blog.youkuaiyun.com/aiynmimi/article/details/54287320

Oracle物化视图快速刷新、多表连接、聚集

https://blog.youkuaiyun.com/demonson/article/details/81451985

Oracle 物化视图 说明

https://www.cnblogs.com/xiaohuilong/p/5995596.html

ORACLE物化视图（物理视图）

https://www.cnblogs.com/qqzy168/p/3689334.html

 

官方文档

https://docs.oracle.com/cd/E11882_01/server.112/e10706/repmview.htm#REPLN266

物化视图的快速刷新

https://yq.aliyun.com/articles/576823

Oracle 物化视图 快速刷新 限制 说明

https://blog.youkuaiyun.com/tianlesoftware/article/details/7719679

Oracle物化视图的创建及使用

https://www.cnblogs.com/jianshuai520/p/10246136.html

 

刚看了一下10g的快速刷新限制条件，明确说明了包含分析函数的物化视图是无法快速刷新的：

General Restrictions on Fast Refresh
The defining query of the materialized view is restricted as follows:

The materialized view must not contain references to non-repeating expressions like SYSDATE and ROWNUM.

The materialized view must not contain references to RAW or LONG RAW data types.

It cannot contain a SELECT list subquery.

It cannot contain analytical functions (for example, RANK) in the SELECT clause.

It cannot contain a MODEL clause.

It cannot contain a HAVING clause with a subquery.

It cannot contain nested queries that have ANY, ALL, or NOT EXISTS.

It cannot contain a [START WITH …] CONNECT BY clause.

It cannot contain multiple detail tables at different sites.

On-commit materialized view cannot have remote detail tables.

Nested materialized views must have a join or aggregate.

转载于:https://www.cnblogs.com/hwubin5/p/10450810.html