enjoy it.
比如一个查询
select t1.*,t2.*,t3.*
from t1,t2,t3
where t1.c1 = t2.c1 and t1.c1 = t3.c1
/
可以分别建立三个表t1,t2,t3快速刷新的物化视图mv_t1,mv_t2,mv_t3,然后建立视图
create view test as
select mv_t1.*,mv_t2.*,mv_t3.*
from mv_t1,mv_t2,mv_t3
where mv_t1.c1 = mv_t2.c1 and mv_t1.c1 = mv_t3.c1
/
该视图性能上与上述查询的物化视图会有不少差距,
就看用户能否接受了.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/6906/viewspace-21588/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/6906/viewspace-21588/