Oracle 物化视图

1、创建物化视图：

create materialized view MV_YHMYDBB PARALLEL 10refresh force on demandstart with sysdate next trunc(sysdate) + 1 + 5/1440asselect ……

2、手动刷新物化视图：

alter materialized view MV_YHMYDBB refresh force;

3、修改物化视图下次刷新时间：

alter  materialized view MV_XZQYSCTJrefresh force on demand next null  

4、实表更新：

truncate table mv_sv_dispatch;insert /*+append*/ into mv_sv_dispatch select /*+parallel(sd 10)*/ SD.REQUEST_ID,               inform_org_id,               MIN(SD.Dispatch_Date) Dispatch_Date          from SV_DISPATCH SD         WHERE SD.DELETED_FLAG = '0'           and SD.Inform_Org_Type = 'SS'         GROUP BY SD.REQUEST_ID, sd.inform_org_id;         commit;

5、建物化视图索引：

create index idx_MV_XZQYSCTJ_1 on MV_XZQYSCTJ(RECEIPT_DATE)