性能测试时,到最后数据量较大时,查询一张视图 (left join 4张表)用时1.67s,经最后与DBA商议需建立物化视图:
-- 注意:当用FAST选项创建物化视图,必须创建基于主表的视图日志,如下:
CREATE MATERIALIZED VIEW LOG ON T_BUET_BUSINESSEVENT;
--为T_BUET_BUSINESSEVENT建立物化视图
CREATE MATERIALIZED VIEW MV_BUET_BUSINESSEVENT
REFRESH FAST START WITH SYSDATENEXT SYSDATE + 1/48
WITH PRIMARY KEY
AS SELECT * FROM T_BUET_BUSINESSEVENT@zfdb;
建立关联主表的物化视图后,查询用时0.87~0.91s,
为其他大数据量表建物化视图后,用时0.7~0.8s
------------------------------------------------------------------------------多表连接建立物化视图-----------------------------------------------------------------------
多表的连接的物化视图,若需建