1、SQL> create materialized view log on t;

2、The materialized view is an important means of increasing the execution efficiency of a data warehouse, but the storage of the materialized view costs space.

3、SQL> create materialized view log on dim_a with row id;

4、SQL> create materialized view log on fact with rowid, sequence (aid, num);

5、The materialized view selection algorithms are closely related to the size of the search space.

6、In many case, there is a question, why so slowly in my inserting, creating index, materialized view

7、The radical database collection which are considered as auxiliary views of multiple materialized view are saved on the integration point.

8、During maintaining the materialized view in the data warehouse, how to efficiently handle the concurrent updates is an important and intractable problem.

9、The latter is one way to maintain the materialized view at the DW without access to the base relations by replicating all or parts of the base data at the DW.