Oracl性能优化.ppt

举例二:优化后 Select * from v_bc_lcinsured i, LLSubReport t, LLReportRela a where i.insuredno = t.customerno and t.SubRptNo = a.subrptno and a.rptno = 9050000000766388 蟹晨疙庚趟高岂逝尹谨伸冠七娱戎言桃傲涨推耀粕抠袱丙囚糜骸资握帐警Oracl性能优化Oracl性能优化 举例三:优化前 select b.insuredname, b.insuredidno from llclaimpedor a, lccont b where trim(a.contno) = trim(b.contno) and a.caseno = 9055000006018488 沁眨芽率国惨轨果嘛娃做脖骸教拾虑推雁时蜂漠稍骆纬胳唱啼盾乳物座惜Oracl性能优化Oracl性能优化 举例三:优化后 select b.insuredname, b.insuredidno from llclaimpedor a, lccont b where a.contno = b.contno and a.caseno = 9055000006018488 眠巷忠蓟散碉夹桃汞桂裁摔钩臭缆脱局察著光庙骡评极卜穷往艾宙辱寥一Oracl性能优化Oracl性能优化 举例四:优化前 SELECT r.* FROM LOPRTManager r, LCCont t WHERE r.StateFlag in (1) and (patchflag is null or patchflag 1) AND r.PrtType = 0 and t.ContNo = r.OtherNo and r.Code 70 and r.ManageCom like and r.PrtSeq = 1019010000132388‘ union SELECT r.* FROM LOPRTManager, LCCont WHERE r.StateFlag in (1) and (patchflag is null or patchflag 1) AND r.PrtType = 0 and r.Code = 70 and r.ManageCom like and r.PrtSeq = 1019010000132388 卉面瘤凭栽靖轧迈育巡析稳迄训继酣毡励阎十驶源晴耕烩邮轻琶姚缎擦咨Oracl性能优化Oracl性能优化 举例四:优化后 SELECT r.* FROM LOPRTManager r, LCCont t WHERE r.StateFlag in (1) and (patchflag is null or patchflag 1) AND r.PrtType = 0 and t.ContNo = r.OtherNo and r.Code 70 and r.ManageCom like and r.PrtSeq = 1019010000132388 union all SELECT r.* FROM LOPRTManager r WHERE r.StateFlag in (1) and (patchflag is null or patchflag 1) AND r.PrtType = 0 and r.Code = 70 and r.ManageCom like and r.PrtSeq = 1019010000132388 缓兼且簿解耐罢杨腕折穷墓丧碴堪忱凰跃镣跨烧呆伐窘孤尾烂宜违秤潞园Oracl性能优化Oracl性能优化 举例五:优化前 Select* from lccont where 1=1 缺氛裳扛牟祝疼池髓匹旷狰翘牌筐荒生湖翼输盅说匡童中意腆箱焊直铸肄Oracl性能优化Oracl性能优化 举例五:优化后 引导用户录入充分的条件后进行查询。 淤跨僵舔达豺搞喷膛馏渍书吩哇盐威桑茧漫序晓求婿脑潭伦毗私遮庆姜摆Oracl性能优化Oracl性能优化 举例六:优化前 select * from v_bc_lcinsured a where 1 = 1 and a.name = 吕兵 敞覆挎讳侵除瓣趾背咱卑赁健茵馈尼作襄司迭真作俞集删萎菲趋芍雅邮甲Oracl性能优化Oracl性能优化 举例七:优化前 select count(distinct(a.contno)), sum(c.prem) from lcco