普通视图和物化视图的区别
Oracle物化视图快速刷新、多表连接、聚集
官方文档
物化视图的快速刷新
Oracle 物化视图 快速刷新 限制 说明
刚看了一下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.