orcle数据库优化实践篇（二）

1、通过物化视图的方式优化数据查询速度：

create materialized view MV_DT_DJXH
refresh force on demand
enable query rewrite
as
select   b.djxh, b.nsrsbh  ,a.cwfzrsfzjhm ,a.bsrsfzjhm
       from dj_nsrxx_kz a, dj_nsrxx b
      where a.djxh = b.djxh  and  b.nsrzt_dm = '03';