![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql优化
Clark_1130
oracle dba
展开
-
sql 优化 -- sql中的自定函数
Long run sql: MERGE INTO INTITMRTNPARAM D USING ( SELECT A.INRFILENM,A.INRSTAT,A.INRDEPCD,A.INRITMCD,A.INRSUBCD,A.INRSUPCD,A.INRSTOCD原创 2016-04-15 11:51:42 · 579 阅读 · 0 评论 -
Oracle 优化器(RBO,CBO)
RBO Path 1: Single Row by RowidRBO Path 2: Single Row by Cluster JoinRBO Path 3: Single Row by Hash Cluster Key with Unique or Primary KeyRBO Path 4: Single Row by Unique or Primary Key原创 2014-11-11 10:41:12 · 616 阅读 · 0 评论 -
同事的sql跑了几个小时,不用看执行计划就能优化
今天同事说sql太慢MERGE INTO FC_BQ_COSTRESULT_PRODUCT AUSING (SELECT SUBSTR(:B1, 1, 4) YEAR, SUBSTR(:B1, 5, 2) PERIOD, T1.PK_DEPTDOC, T1.ROOTDEPT,原创 2014-11-27 15:12:51 · 463 阅读 · 0 评论