![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle SQL优化案例与测试
Oracle SQL优化案例与测试
DBhanG
这个作者很懒,什么都没留下…
展开
-
Oracle SQL多表关联索引优化案例
近期迁云,云上磁盘性能很差,对当前数据库优化IO如下SQL消耗IO资源很高:SELECT SUM("A2"."FEE_CASH"), '1',"A1"."CHL_REFUND_NO","A2"."PAYPLAT_TRADNO", 2 FROM (SELECT MAX("A4"."UUID") "MAX(TTTT.UUID)" FROM "HUZH_CREDIT"."B_SETTILE_DATA" "A4" GROUP BY "A原创 2021-09-07 17:52:00 · 1983 阅读 · 0 评论 -
Oracle 大表回表过滤优化案例
某业务报表SQL:执行时间3小时.asncn3a24zu67SELECT NVL(XHSD0001.CG_F_GHSMC_TONGJI_SPBS_CGB(FHMX.SPBS), '0000000000') KHBH, FHMX.CGBMBH, ROUND(SUM(DECODE(FHMX.CLZT, 'e', FHMX.SFSL, FHMX.SSSL)), 0) SL, SUM(FHMX.MY) MY, SUM(FHMX.SY) S原创 2021-09-07 16:51:47 · 1129 阅读 · 0 评论 -
Oracle VIEW PUSHED PREDICATE案例分析
SELECT * FROM (SELECTA.INVOICE_ID, A.VENDOR_ID, A.INVOICE_NUM, A.INVOICE_AMOUNT, A.GL_DATE, A.INVOICE_CURRENCY_CODE, SUM(NVL(B.PREPAY_AMOUNT_APPLIED,0)) PAID_AMOUNT原创 2021-08-31 16:35:33 · 986 阅读 · 0 评论