赞
踩
将查询结果进行缓存,极大提升视图查询速率
需要定时更新结果至缓存
create materialized view view_name as query_sql;
create materialized view view_name as query_sql with no data;
refresh materialized view view_name;
原理:将创建物化视图的临时更新版本,比较更新版本和原视图两个版本,并执行 insert 和 update
使用要求:
create unique index index_name on view_name (列名1,列名2...);
刷新语句:
refresh materialized view concurrently view_name;
drop materialized view if exists view_name;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。