ITPub博客

有两篇网上的文章结合着看比较好http://www.chinaitpower.com/A/2002-05-02/21578.html提供了笼统的mv的概貌介绍http://yangtingkun.itpub.net/post/468/11356提供了定义物化视图的子句的详细介绍http://dev.csdn.net/article/45/45638.shtm有些权限说明及注意问题自己也做了个简单测试：见内[@more@]需要主键cycker> create materialized view mv_robincui refresh fast on commit with primary key as select * from robincui;create materialized view mv_robincui refresh fast on commit with primary key as select * from robin