具有快速刷新特性的物化视图的子查询遵循的限制

1 Materialized views must be primary key materialized views.
2 the master's materialized view logs must include certain columns referenced in the subquery.
3 if the subquery is many to many or one to many , join columns that are not part of a primary key must be include in the materialized view log of the master .this restriction dose not apply to many to one subqueries.
4 the subquery must be a positive subquery . for example , you can use EXISTS, but not NOT EXISTS.
5 the subquery must use EXISTS to connect each nested level(IN is not allowed).
6 each table can be in only EXISTS expression.
7 the join expression must use exact match or equality comparisons(that is equi-joins)
8 each table can be joined only once within the subquery.
9 a primary key must exist for each table at each nested level.
10 each nested level can only reference the table in the level above it.
11 subqueries can include AND operators, but each OR operator may only reference columns contained with one row. Multiple OR operator within a subquery can be connected with an AND operator.
12 All tables referenced wi in a subquery must be reside in the master site or master materialized view site.