https://ask.oceanbase.com/t/topic/35617564 -》》》 这两天发现系统存在一条慢SQL， SQL具体内容如下： SELECT aaa.ID, aaa.BUS_ID, aaa.HIS_BUS_ID, aaa.EAST_RP_TYPE, aaa.YBJ_RP_TYPE, aaa.RP_NAME, aaa.YBJ_CARD_TYPE, aaa.EAST_CARD_TYPE, aaa.RELATION_NATURE, aaa.CARD_NO, aaa.CUST_NO, aaa.DOMESTIC_STATE, aaa.COMPANY_TYPE, aaa.ECONOMIC_NATURE, aaa.BUSINESS_STATE, aaa.REGISTERED_CAPITAL, aaa.REPRESENTATIVE, aaa.BLOC_STATE, aaa.BLOC_ID, aaa.BLOC_NAME, aaa.BLOC_CARD_NO, aaa.REGISTERED, aaa.ECONOMIC_SCOPE, aaa.EAST_RELATION_TYPE, aaa.INDUSTRY_CODE, aaa.INDUSTRY_NAME, aaa.REA_NO, aaa.REA_DESC, aaa.INST_ORG, aaa.REMARKS, aaa.DATA_STATE, aaa.EFFECT_STATE, aaa.ACTIVE_TIME, aaa.INVALID_TIME, aaa.DATA_SOURCE, aaa.LEGAL_ORG_CODE, aaa.CREATE_USER, aaa.CREATE_TIME, aaa.CREATE_ORG, aaa.CREATE_DEP, aaa.UPDATE_USER, aaa.UPDATE_TIME, aaa.UPDATE_ORG, aaa.UPDATE_DEP, aaa.WF_STATE, aaa.AGREE, aaa.PROCESS_INSTANCE_ID, aaa.RESERVE1, aaa.RESERVE2, aaa.RESERVE3, aaa.DATA_DT, rrrp.SUPER_RP_NAME, rrrp.SUPER_YBJ_CARD_TYPE, rrrp.SUPER_CARD_NO, rrrp.RELATION_TYPE, rrrp.IS_SHARE_HOLDING, rrrp.HOLDING_PCT, rrrp.RELATION_INFO, rrrp.VALID_STATE, rrrp.ACTIVE_TIME, rrrp.INVALID_TIME, rrrp.RELEASE_TIME, rrrp.REMARKS AS RELATION_REMARKS, ( SELECT r.RP_NAME FROM rtm_rp_his_legal r WHERE aaa.BLOC_ID = r.BUS_ID AND aaa.HIS_BUS_ID = r.HIS_BUS_ID ) AS BLOC_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.EAST_RP_TYPE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS EAST_RP_TYPE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.YBJ_CARD_TYPE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS YBJ_CARD_TYPE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.EAST_CARD_TYPE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS EAST_CARD_TYPE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.EAST_RELATION_TYPE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS EAST_RELATION_TYPE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.DOMESTIC_STATE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS DOMESTIC_STATE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.COMPANY_TYPE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS COMPANY_TYPE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = aaa.BLOC_STATE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS BLOC_STATE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = rrrp.RELATION_TYPE AND DCT_TP_CD = ? AND DEL_IND = ? ) AS RELATION_TYPE_NAME, ( SELECT DCT_VAL_NM FROM base_ddct WHERE DCT_VAL = rrrp.IS_SHARE_HOLDING AND DCT_TP_CD = ? AND DEL_IND = ? ) AS IS_SHARE_HOLDING_NAME FROM rtm_rp_his_legal aaa LEFT JOIN rtm_rp_his_relation rrrp ON aaa.BUS_ID = rrrp.ENTITY_BUS_ID AND aaa.HIS_BUS_ID = rrrp.HIS_BUS_ID WHERE aaa.HIS_BUS_ID = ? AND aaa.RELATION_NATURE != ? -》》》 2.2 进入该表所对应的数据库： explain EXTENDED SELECT ========================================================= |ID|OPERATOR |NAME |EST. ROWS|COST | --------------------------------------------------------- |0 |SUBPLAN FILTER | |2928 |745270739| |1 | HASH RIGHT OUTER JOIN| |2928 |1256991 | |2 | TABLE SCAN |rrrp |4782 |995569 | |3 | TABLE SCAN |aaa |1622 |252665 | |4 | TABLE SCAN |r |1 |252665 | |5 | TABLE SCAN |base_ddct|1 |162 | |6 | TABLE SCAN |base_ddct|1 |162 | |7 | TABLE SCAN |base_ddct|1 |162 | |8 | TABLE SCAN |base_ddct|1 |162 | |9 | TABLE SCAN |base_ddct|1 |162 | |10| TABLE SCAN |base_ddct|1 |162 | |11| TABLE SCAN |base_ddct|1 |162 | |12| TABLE SCAN |base_ddct|1 |162 | |13| TABLE SCAN |base_ddct|1 |162 | ========================================================= Outputs & filters: ------------------------------------- 0 - output([aaa.ID(0x7fa78f949770)], [aaa.BUS_ID(0x7fa78f945ae0)], [aaa.HIS_BUS_ID(0x7fa78f946f20)], [aaa.EAST_RP_TYPE(0x7fa78f94a400)], [aaa.YBJ_RP_TYPE(0x7fa78f94aa30)], [aaa.RP_NAME(0x7fa78f94b060)], [aaa.YBJ_CARD_TYPE(0x7fa78f94b690)], [aaa.EAST_CARD_TYPE(0x7fa78f94bcc0)], [aaa.RELATION_NATURE(0x7fa78f949080)], [aaa.CARD_NO(0x7fa78f94c620)], [aaa.CUST_NO(0x7fa78f94cc50)], [aaa.DOMESTIC_STATE(0x7fa78f94d280)], [aaa.COMPANY_TYPE(0x7fa78f94d8b0)], [aaa.ECONOMIC_NATURE(0x7fa78f94dee0)], [aaa.BUSINESS_STATE(0x7fa78f94e510)], [aaa.REGISTERED_CAPITAL(0x7fa78f950b50)], [aaa.REPRESENTATIVE(0x7fa78f951180)], [aaa.BLOC_STATE(0x7fa78f95f7c0)], [aaa.BLOC_ID(0x7fa78f95fdf0)], [aaa.BLOC_NAME(0x7fa78f960420)], [aaa.BLOC_CARD_NO(0x7fa78f960a50)], [aaa.REGISTERED(0x7fa78f961080)], [aaa.ECONOMIC_SCOPE(0x7fa78f9616b0)], [aaa.EAST_RELATION_TYPE(0x7fa78f961ce0)], [aaa.INDUSTRY_CODE(0x7fa78f962310)], [aaa.INDUSTRY_NAME(0x7fa78f962940)], [aaa.REA_NO(0x7fa78f962f70)], [aaa.REA_DESC(0x7fa78f9635a0)], [aaa.INST_ORG(0x7fa78f963bd0)], [aaa.REMARKS(0x7fa78f964200)], [aaa.DATA_STATE(0x7fa78f964830)], [aaa.EFFECT_STATE(0x7fa78f964e60)], [aaa.ACTIVE_TIME(0x7fa78f965490)], [aaa.INVALID_TIME(0x7fa78f965ac0)], [aaa.DATA_SOURCE(0x7fa78f9660f0)], [aaa.LEGAL_ORG_CODE(0x7fa78f966720)], [aaa.CREATE_USER(0x7fa78f966d50)], [aaa.CREATE_TIME(0x7fa78f983390)], [aaa.CREATE_ORG(0x7fa78f9839c0)], [aaa.CREATE_DEP(0x7fa78f983ff0)], [aaa.UPDATE_USER(0x7fa78f984620)], [aaa.UPDATE_TIME(0x7fa78f984c50)], [aaa.UPDATE_ORG(0x7fa78f985280)], [aaa.UPDATE_DEP(0x7fa78f9858b0)], [aaa.WF_STATE(0x7fa78f985ee0)], [aaa.AGREE(0x7fa78f986510)], [aaa.PROCESS_INSTANCE_ID(0x7fa78f986b40)], [aaa.RESERVE1(0x7fa78f987170)], [aaa.RESERVE2(0x7fa78f9877a0)], [aaa.RESERVE3(0x7fa78f987dd0)], [aaa.DATA_DT(0x7fa78f988400)], [rrrp.SUPER_RP_NAME(0x7fa78f988a30)], [rrrp.SUPER_YBJ_CARD_TYPE(0x7fa78f989060)], [rrrp.SUPER_CARD_NO(0x7fa78f989690)], [rrrp.RELATION_TYPE(0x7fa78f989cc0)], [rrrp.IS_SHARE_HOLDING(0x7fa78f98a2f0)], [rrrp.HOLDING_PCT(0x7fa78f98a920)], [rrrp.RELATION_INFO(0x7fa78f98af50)], [rrrp.VALID_STATE(0x7fa78f98b580)], [rrrp.ACTIVE_TIME(0x7fa78f98bbb0)], [rrrp.INVALID_TIME(0x7fa78f98c1e0)], [rrrp.RELEASE_TIME(0x7fa78f98c810)], [rrrp.REMARKS(0x7fa78f98ce40)], [subquery(1)(0x7fa78f98d150)], [subquery(2)(0x7fa78f9d8820)], [subquery(3)(0x7fa78fa25d30)], [subquery(4)(0x7fa78fa73240)], [subquery(5)(0x7f95764810e0)], [subquery(6)(0x7f95764d0600)], [subquery(7)(0x7f957651db10)], [subquery(8)(0x7f957656b020)], [subquery(9)(0x7f95765b8530)], [subquery(10)(0x7f9576605a40)]), filter(nil), exec_params_([aaa.BLOC_ID(0x7fa78f95fdf0)], [cast(aaa.EAST_RP_TYPE(0x7fa78f94a400), VARCHAR(1048576))(0x7fa78fa22d20)], [cast(aaa.YBJ_CARD_TYPE(0x7fa78f94b690), VARCHAR(1048576))(0x7fa78fa70230)], [cast(aaa.EAST_CARD_TYPE(0x7fa78f94bcc0), VARCHAR(1048576))(0x7f957647e0d0)], [cast(aaa.EAST_RELATION_TYPE(0x7fa78f961ce0), VARCHAR(1048576))(0x7f95764cb5e0)], [cast(aaa.DOMESTIC_STATE(0x7fa78f94d280), VARCHAR(1048576))(0x7f957651ab00)], [cast(aaa.COMPANY_TYPE(0x7fa78f94d8b0), VARCHAR(1048576))(0x7f9576568010)], [cast(aaa.BLOC_STATE(0x7fa78f95f7c0), VARCHAR(1048576))(0x7f95765b5520)], [cast(rrrp.RELATION_TYPE(0x7fa78f989cc0), VARCHAR(1048576))(0x7f9576602a30)], [cast(rrrp.IS_SHARE_HOLDING(0x7fa78f98a2f0), VARCHAR(1048576))(0x7f957664ff40)]), onetime_exprs_(nil), init_plan_idxs_(nil) 1 - output([aaa.ID(0x7fa78f949770)], [aaa.BUS_ID(0x7fa78f945ae0)], [aaa.HIS_BUS_ID(0x7fa78f946f20)], [aaa.EAST_RP_TYPE(0x7fa78f94a400)], [aaa.YBJ_RP_TYPE(0x7fa78f94aa30)], [aaa.RP_NAME(0x7fa78f94b060)], [aaa.YBJ_CARD_TYPE(0x7fa78f94b690)], [aaa.EAST_CARD_TYPE(0x7fa78f94bcc0)], [aaa.RELATION_NATURE(0x7fa78f949080)], [aaa.CARD_NO(0x7fa78f94c620)], [aaa.CUST_NO(0x7fa78f94cc50)], [aaa.DOMESTIC_STATE(0x7fa78f94d280)], [aaa.COMPANY_TYPE(0x7fa78f94d8b0)], [aaa.ECONOMIC_NATURE(0x7fa78f94dee0)], [aaa.BUSINESS_STATE(0x7fa78f94e510)], [aaa.REGISTERED_CAPITAL(0x7fa78f950b50)], [aaa.REPRESENTATIVE(0x7fa78f951180)], [aaa.BLOC_STATE(0x7fa78f95f7c0)], [aaa.BLOC_ID(0x7fa78f95fdf0)], [aaa.BLOC_NAME(0x7fa78f960420)], [aaa.BLOC_CARD_NO(0x7fa78f960a50)], [aaa.REGISTERED(0x7fa78f961080)], [aaa.ECONOMIC_SCOPE(0x7fa78f9616b0)], [aaa.EAST_RELATION_TYPE(0x7fa78f961ce0)], [aaa.INDUSTRY_CODE(0x7fa78f962310)], [aaa.INDUSTRY_NAME(0x7fa78f962940)], [aaa.REA_NO(0x7fa78f962f70)], [aaa.REA_DESC(0x7fa78f9635a0)], [aaa.INST_ORG(0x7fa78f963bd0)], [aaa.REMARKS(0x7fa78f964200)], [aaa.DATA_STATE(0x7fa78f964830)], [aaa.EFFECT_STATE(0x7fa78f964e60)], [aaa.ACTIVE_TIME(0x7fa78f965490)], [aaa.INVALID_TIME(0x7fa78f965ac0)], [aaa.DATA_SOURCE(0x7fa78f9660f0)], [aaa.LEGAL_ORG_CODE(0x7fa78f966720)], [aaa.CREATE_USER(0x7fa78f966d50)], [aaa.CREATE_TIME(0x7fa78f983390)], [aaa.CREATE_ORG(0x7fa78f9839c0)], [aaa.CREATE_DEP(0x7fa78f983ff0)], [aaa.UPDATE_USER(0x7fa78f984620)], [aaa.UPDATE_TIME(0x7fa78f984c50)], [aaa.UPDATE_ORG(0x7fa78f985280)], [aaa.UPDATE_DEP(0x7fa78f9858b0)], [aaa.WF_STATE(0x7fa78f985ee0)], [aaa.AGREE(0x7fa78f986510)], [aaa.PROCESS_INSTANCE_ID(0x7fa78f986b40)], [aaa.RESERVE1(0x7fa78f987170)], [aaa.RESERVE2(0x7fa78f9877a0)], [aaa.RESERVE3(0x7fa78f987dd0)], [aaa.DATA_DT(0x7fa78f988400)], [rrrp.SUPER_RP_NAME(0x7fa78f988a30)], [rrrp.SUPER_YBJ_CARD_TYPE(0x7fa78f989060)], [rrrp.SUPER_CARD_NO(0x7fa78f989690)], [rrrp.RELATION_TYPE(0x7fa78f989cc0)], [rrrp.IS_SHARE_HOLDING(0x7fa78f98a2f0)], [rrrp.HOLDING_PCT(0x7fa78f98a920)], [rrrp.RELATION_INFO(0x7fa78f98af50)], [rrrp.VALID_STATE(0x7fa78f98b580)], [rrrp.ACTIVE_TIME(0x7fa78f98bbb0)], [rrrp.INVALID_TIME(0x7fa78f98c1e0)], [rrrp.RELEASE_TIME(0x7fa78f98c810)], [rrrp.REMARKS(0x7fa78f98ce40)]), filter(nil), equal_conds([aaa.BUS_ID(0x7fa78f945ae0) = rrrp.ENTITY_BUS_ID(0x7fa78f945de0)(0x7fa78f9453c0)], [aaa.HIS_BUS_ID(0x7fa78f946f20) = rrrp.HIS_BUS_ID(0x7fa78f947220)(0x7fa78f946800)]), other_conds(nil) 2 - output([rrrp.ENTITY_BUS_ID(0x7fa78f945de0)], [rrrp.HIS_BUS_ID(0x7fa78f947220)], [rrrp.SUPER_RP_NAME(0x7fa78f988a30)], [rrrp.SUPER_YBJ_CARD_TYPE(0x7fa78f989060)], [rrrp.SUPER_CARD_NO(0x7fa78f989690)], [rrrp.RELATION_TYPE(0x7fa78f989cc0)], [rrrp.IS_SHARE_HOLDING(0x7fa78f98a2f0)], [rrrp.HOLDING_PCT(0x7fa78f98a920)], [rrrp.RELATION_INFO(0x7fa78f98af50)], [rrrp.VALID_STATE(0x7fa78f98b580)], [rrrp.ACTIVE_TIME(0x7fa78f98bbb0)], [rrrp.INVALID_TIME(0x7fa78f98c1e0)], [rrrp.RELEASE_TIME(0x7fa78f98c810)], [rrrp.REMARKS(0x7fa78f98ce40)]), filter([rrrp.HIS_BUS_ID(0x7fa78f947220) = 'RPSHL2a77416389872d41f764b47169676f66'(0x7f957666f2c0)]), access([rrrp.ENTITY_BUS_ID(0x7fa78f945de0)], [rrrp.HIS_BUS_ID(0x7fa78f947220)], [rrrp.SUPER_RP_NAME(0x7fa78f988a30)], [rrrp.SUPER_YBJ_CARD_TYPE(0x7fa78f989060)], [rrrp.SUPER_CARD_NO(0x7fa78f989690)], [rrrp.RELATION_TYPE(0x7fa78f989cc0)], [rrrp.IS_SHARE_HOLDING(0x7fa78f98a2f0)], [rrrp.HOLDING_PCT(0x7fa78f98a920)], [rrrp.RELATION_INFO(0x7fa78f98af50)], [rrrp.VALID_STATE(0x7fa78f98b580)], [rrrp.ACTIVE_TIME(0x7fa78f98bbb0)], [rrrp.INVALID_TIME(0x7fa78f98c1e0)], [rrrp.RELEASE_TIME(0x7fa78f98c810)], [rrrp.REMARKS(0x7fa78f98ce40)]), partitions(p0), is_index_back=false, filter_before_indexback[false], range_key([rrrp.ID(0x7f59ebe503a0)]), range(MIN ; MAX)always true 3 - output([aaa.BUS_ID(0x7fa78f945ae0)], [aaa.HIS_BUS_ID(0x7fa78f946f20)], [aaa.RELATION_NATURE(0x7fa78f949080)], [aaa.ID(0x7fa78f949770)], [aaa.EAST_RP_TYPE(0x7fa78f94a400)], [aaa.YBJ_RP_TYPE(0x7fa78f94aa30)], [aaa.RP_NAME(0x7fa78f94b060)], [aaa.YBJ_CARD_TYPE(0x7fa78f94b690)], [aaa.EAST_CARD_TYPE(0x7fa78f94bcc0)], [aaa.CARD_NO(0x7fa78f94c620)], [aaa.CUST_NO(0x7fa78f94cc50)], [aaa.DOMESTIC_STATE(0x7fa78f94d280)], [aaa.COMPANY_TYPE(0x7fa78f94d8b0)], [aaa.ECONOMIC_NATURE(0x7fa78f94dee0)], [aaa.BUSINESS_STATE(0x7fa78f94e510)], [aaa.REGISTERED_CAPITAL(0x7fa78f950b50)], [aaa.REPRESENTATIVE(0x7fa78f951180)], [aaa.BLOC_STATE(0x7fa78f95f7c0)], [aaa.BLOC_ID(0x7fa78f95fdf0)], [aaa.BLOC_NAME(0x7fa78f960420)], [aaa.BLOC_CARD_NO(0x7fa78f960a50)], [aaa.REGISTERED(0x7fa78f961080)], [aaa.ECONOMIC_SCOPE(0x7fa78f9616b0)], [aaa.EAST_RELATION_TYPE(0x7fa78f961ce0)], [aaa.INDUSTRY_CODE(0x7fa78f962310)], [aaa.INDUSTRY_NAME(0x7fa78f962940)], [aaa.REA_NO(0x7fa78f962f70)], [aaa.REA_DESC(0x7fa78f9635a0)], [aaa.INST_ORG(0x7fa78f963bd0)], [aaa.REMARKS(0x7fa78f964200)], [aaa.DATA_STATE(0x7fa78f964830)], [aaa.EFFECT_STATE(0x7fa78f964e60)], [aaa.ACTIVE_TIME(0x7fa78f965490)], [aaa.INVALID_TIME(0x7fa78f965ac0)], [aaa.DATA_SOURCE(0x7fa78f9660f0)], [aaa.LEGAL_ORG_CODE(0x7fa78f966720)], [aaa.CREATE_USER(0x7fa78f966d50)], [aaa.CREATE_TIME(0x7fa78f983390)], [aaa.CREATE_ORG(0x7fa78f9839c0)], [aaa.CREATE_DEP(0x7fa78f983ff0)], [aaa.UPDATE_USER(0x7fa78f984620)], [aaa.UPDATE_TIME(0x7fa78f984c50)], [aaa.UPDATE_ORG(0x7fa78f985280)], [aaa.UPDATE_DEP(0x7fa78f9858b0)], [aaa.WF_STATE(0x7fa78f985ee0)], [aaa.AGREE(0x7fa78f986510)], [aaa.PROCESS_INSTANCE_ID(0x7fa78f986b40)], [aaa.RESERVE1(0x7fa78f987170)], [aaa.RESERVE2(0x7fa78f9877a0)], [aaa.RESERVE3(0x7fa78f987dd0)], [aaa.DATA_DT(0x7fa78f988400)]), filter([aaa.HIS_BUS_ID(0x7fa78f946f20) = 'RPSHL2a77416389872d41f764b47169676f66'(0x7fa78f947bb0)], [aaa.RELATION_NATURE(0x7fa78f949080) != '02'(0x7fa78f948960)]), access([aaa.BUS_ID(0x7fa78f945ae0)], [aaa.HIS_BUS_ID(0x7fa78f946f20)], [aaa.RELATION_NATURE(0x7fa78f949080)], [aaa.ID(0x7fa78f949770)], [aaa.EAST_RP_TYPE(0x7fa78f94a400)], [aaa.YBJ_RP_TYPE(0x7fa78f94aa30)], [aaa.RP_NAME(0x7fa78f94b060)], [aaa.YBJ_CARD_TYPE(0x7fa78f94b690)], [aaa.EAST_CARD_TYPE(0x7fa78f94bcc0)], [aaa.CARD_NO(0x7fa78f94c620)], [aaa.CUST_NO(0x7fa78f94cc50)], [aaa.DOMESTIC_STATE(0x7fa78f94d280)], [aaa.COMPANY_TYPE(0x7fa78f94d8b0)], [aaa.ECONOMIC_NATURE(0x7fa78f94dee0)], [aaa.BUSINESS_STATE(0x7fa78f94e510)], [aaa.REGISTERED_CAPITAL(0x7fa78f950b50)], [aaa.REPRESENTATIVE(0x7fa78f951180)], [aaa.BLOC_STATE(0x7fa78f95f7c0)], [aaa.BLOC_ID(0x7fa78f95fdf0)], [aaa.BLOC_NAME(0x7fa78f960420)], [aaa.BLOC_CARD_NO(0x7fa78f960a50)], [aaa.REGISTERED(0x7fa78f961080)], [aaa.ECONOMIC_SCOPE(0x7fa78f9616b0)], [aaa.EAST_RELATION_TYPE(0x7fa78f961ce0)], [aaa.INDUSTRY_CODE(0x7fa78f962310)], [aaa.INDUSTRY_NAME(0x7fa78f962940)], [aaa.REA_NO(0x7fa78f962f70)], [aaa.REA_DESC(0x7fa78f9635a0)], [aaa.INST_ORG(0x7fa78f963bd0)], [aaa.REMARKS(0x7fa78f964200)], [aaa.DATA_STATE(0x7fa78f964830)], [aaa.EFFECT_STATE(0x7fa78f964e60)], [aaa.ACTIVE_TIME(0x7fa78f965490)], [aaa.INVALID_TIME(0x7fa78f965ac0)], [aaa.DATA_SOURCE(0x7fa78f9660f0)], [aaa.LEGAL_ORG_CODE(0x7fa78f966720)], [aaa.CREATE_USER(0x7fa78f966d50)], [aaa.CREATE_TIME(0x7fa78f983390)], [aaa.CREATE_ORG(0x7fa78f9839c0)], [aaa.CREATE_DEP(0x7fa78f983ff0)], [aaa.UPDATE_USER(0x7fa78f984620)], [aaa.UPDATE_TIME(0x7fa78f984c50)], [aaa.UPDATE_ORG(0x7fa78f985280)], [aaa.UPDATE_DEP(0x7fa78f9858b0)], [aaa.WF_STATE(0x7fa78f985ee0)], [aaa.AGREE(0x7fa78f986510)], [aaa.PROCESS_INSTANCE_ID(0x7fa78f986b40)], [aaa.RESERVE1(0x7fa78f987170)], [aaa.RESERVE2(0x7fa78f9877a0)], [aaa.RESERVE3(0x7fa78f987dd0)], [aaa.DATA_DT(0x7fa78f988400)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false], range_key([aaa.ID(0x7fa78f949770)], [aaa.CARD_NO(0x7fa78f94c620)]), range(MIN,MIN ; MAX,MAX)always true 4 - output([r.RP_NAME(0x7fa78f9d6180)]), filter([? = r.BUS_ID(0x7fa78f9d4950)(0x7fa78f9d4230)], [r.HIS_BUS_ID(0x7fa78f9d5a90) = 'RPSHL2a77416389872d41f764b47169676f66'(0x7f9576666f10)]), access([r.BUS_ID(0x7fa78f9d4950)], [r.HIS_BUS_ID(0x7fa78f9d5a90)], [r.RP_NAME(0x7fa78f9d6180)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false], range_key([r.ID(0x7f59ebe8c150)], [r.CARD_NO(0x7f59ebe8c450)]), range(MIN,MIN ; MAX,MAX)always true 5 - output([base_ddct.DCT_VAL_NM(0x7fa78fa22860)]), filter([cast(base_ddct.DEL_IND(0x7fa78fa22170), DECIMAL(-1, -1))(0x7fa78fa246e0) = ?(0x7fa78fa21a50)], [base_ddct.DCT_TP_CD(0x7fa78fa210c0) = ?(0x7fa78fa209a0)], [base_ddct.DCT_VAL(0x7fa78fa20010) = ?(0x7fa78fa1f8f0)]), access([base_ddct.DCT_VAL(0x7fa78fa20010)], [base_ddct.DCT_TP_CD(0x7fa78fa210c0)], [base_ddct.DEL_IND(0x7fa78fa22170)], [base_ddct.DCT_VAL_NM(0x7fa78fa22860)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebebb560)]), range(MIN ; MAX)always true 6 - output([base_ddct.DCT_VAL_NM(0x7fa78fa6fd70)]), filter([cast(base_ddct.DEL_IND(0x7fa78fa6f680), DECIMAL(-1, -1))(0x7fa78fa71bf0) = ?(0x7fa78fa6ef60)], [base_ddct.DCT_TP_CD(0x7fa78fa6e5d0) = ?(0x7fa78fa6deb0)], [base_ddct.DCT_VAL(0x7fa78fa6d520) = ?(0x7fa78fa6ce00)]), access([base_ddct.DCT_VAL(0x7fa78fa6d520)], [base_ddct.DCT_TP_CD(0x7fa78fa6e5d0)], [base_ddct.DEL_IND(0x7fa78fa6f680)], [base_ddct.DCT_VAL_NM(0x7fa78fa6fd70)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebee69d0)]), range(MIN ; MAX)always true 7 - output([base_ddct.DCT_VAL_NM(0x7fa78fabd280)]), filter([cast(base_ddct.DEL_IND(0x7fa78fabcb90), DECIMAL(-1, -1))(0x7f957647fa90) = ?(0x7fa78fabc470)], [base_ddct.DCT_TP_CD(0x7fa78fabbae0) = ?(0x7fa78fabb3c0)], [base_ddct.DCT_VAL(0x7fa78fabaa30) = ?(0x7fa78faba310)]), access([base_ddct.DCT_VAL(0x7fa78fabaa30)], [base_ddct.DCT_TP_CD(0x7fa78fabbae0)], [base_ddct.DEL_IND(0x7fa78fabcb90)], [base_ddct.DCT_VAL_NM(0x7fa78fabd280)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebf11e40)]), range(MIN ; MAX)always true 8 - output([base_ddct.DCT_VAL_NM(0x7f95764cb120)]), filter([cast(base_ddct.DEL_IND(0x7f95764caa30), DECIMAL(-1, -1))(0x7f95764ccfa0) = ?(0x7f95764ca310)], [base_ddct.DCT_TP_CD(0x7f95764c9980) = ?(0x7f95764c9260)], [base_ddct.DCT_VAL(0x7f95764c88d0) = ?(0x7f95764c81b0)]), access([base_ddct.DCT_VAL(0x7f95764c88d0)], [base_ddct.DCT_TP_CD(0x7f95764c9980)], [base_ddct.DEL_IND(0x7f95764caa30)], [base_ddct.DCT_VAL_NM(0x7f95764cb120)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebf3d2b0)]), range(MIN ; MAX)always true 9 - output([base_ddct.DCT_VAL_NM(0x7f957651a640)]), filter([cast(base_ddct.DEL_IND(0x7f9576519f50), DECIMAL(-1, -1))(0x7f957651c4c0) = ?(0x7f9576519830)], [base_ddct.DCT_TP_CD(0x7f9576518ea0) = ?(0x7f9576518780)], [base_ddct.DCT_VAL(0x7f9576517df0) = ?(0x7f95765176d0)]), access([base_ddct.DCT_VAL(0x7f9576517df0)], [base_ddct.DCT_TP_CD(0x7f9576518ea0)], [base_ddct.DEL_IND(0x7f9576519f50)], [base_ddct.DCT_VAL_NM(0x7f957651a640)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebf6a730)]), range(MIN ; MAX)always true 10 - output([base_ddct.DCT_VAL_NM(0x7f9576567b50)]), filter([cast(base_ddct.DEL_IND(0x7f9576567460), DECIMAL(-1, -1))(0x7f95765699d0) = ?(0x7f9576566d40)], [base_ddct.DCT_TP_CD(0x7f95765663b0) = ?(0x7f9576565c90)], [base_ddct.DCT_VAL(0x7f9576565300) = ?(0x7f9576564be0)]), access([base_ddct.DCT_VAL(0x7f9576565300)], [base_ddct.DCT_TP_CD(0x7f95765663b0)], [base_ddct.DEL_IND(0x7f9576567460)], [base_ddct.DCT_VAL_NM(0x7f9576567b50)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebf95ba0)]), range(MIN ; MAX)always true 11 - output([base_ddct.DCT_VAL_NM(0x7f95765b5060)]), filter([cast(base_ddct.DEL_IND(0x7f95765b4970), DECIMAL(-1, -1))(0x7f95765b6ee0) = ?(0x7f95765b4250)], [base_ddct.DCT_TP_CD(0x7f95765b38c0) = ?(0x7f95765b31a0)], [base_ddct.DCT_VAL(0x7f95765b2810) = ?(0x7f95765b20f0)]), access([base_ddct.DCT_VAL(0x7f95765b2810)], [base_ddct.DCT_TP_CD(0x7f95765b38c0)], [base_ddct.DEL_IND(0x7f95765b4970)], [base_ddct.DCT_VAL_NM(0x7f95765b5060)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebfc3020)]), range(MIN ; MAX)always true 12 - output([base_ddct.DCT_VAL_NM(0x7f9576602570)]), filter([cast(base_ddct.DEL_IND(0x7f9576601e80), DECIMAL(-1, -1))(0x7f95766043f0) = ?(0x7f9576601760)], [base_ddct.DCT_TP_CD(0x7f9576600dd0) = ?(0x7f95766006b0)], [base_ddct.DCT_VAL(0x7f95765ffd20) = ?(0x7f95765ff600)]), access([base_ddct.DCT_VAL(0x7f95765ffd20)], [base_ddct.DCT_TP_CD(0x7f9576600dd0)], [base_ddct.DEL_IND(0x7f9576601e80)], [base_ddct.DCT_VAL_NM(0x7f9576602570)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f59ebfee490)]), range(MIN ; MAX)always true 13 - output([base_ddct.DCT_VAL_NM(0x7f957664fa80)]), filter([cast(base_ddct.DEL_IND(0x7f957664f390), DECIMAL(-1, -1))(0x7f9576651900) = ?(0x7f957664ec70)], [base_ddct.DCT_TP_CD(0x7f957664e2e0) = ?(0x7f957664dbc0)], [base_ddct.DCT_VAL(0x7f957664d230) = ?(0x7f957664cb10)]), access([base_ddct.DCT_VAL(0x7f957664d230)], [base_ddct.DCT_TP_CD(0x7f957664e2e0)], [base_ddct.DEL_IND(0x7f957664f390)], [base_ddct.DCT_VAL_NM(0x7f957664fa80)]), partitions(p0), is_index_back=false, filter_before_indexback[false,false,false], range_key([base_ddct.ID(0x7f62e401f3a0)]), range(MIN ; MAX)always true Used Hint: ------------------------------------- /*+ */ Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA LEADING(@"SEL$1" ("rtmsdata.rrrp"@"SEL$1" "rtmsdata.aaa"@"SEL$1" )) USE_HASH(@"SEL$1" ("rtmsdata.aaa"@"SEL$1" )) PQ_DISTRIBUTE(@"SEL$1" ("rtmsdata.aaa"@"SEL$1" ) LOCAL LOCAL) FULL(@"SEL$1" "rtmsdata.rrrp"@"SEL$1") FULL(@"SEL$1" "rtmsdata.aaa"@"SEL$1") FULL(@"SEL$2" "rtmsdata.r"@"SEL$2") FULL(@"SEL$3" "rtmsdata.base_ddct"@"SEL$3") FULL(@"SEL$4" "rtmsdata.base_ddct"@"SEL$4") FULL(@"SEL$5" "rtmsdata.base_ddct"@"SEL$5") FULL(@"SEL$6" "rtmsdata.base_ddct"@"SEL$6") FULL(@"SEL$7" "rtmsdata.base_ddct"@"SEL$7") FULL(@"SEL$8" "rtmsdata.base_ddct"@"SEL$8") FULL(@"SEL$9" "rtmsdata.base_ddct"@"SEL$9") FULL(@"SEL$10" "rtmsdata.base_ddct"@"SEL$10") FULL(@"SEL$11" "rtmsdata.base_ddct"@"SEL$11") END_OUTLINE_DATA */ Plan Type: ------------------------------------- LOCAL Optimization Info: ------------------------------------- rrrp:table_rows:2524359, physical_range_rows:2534203, logical_range_rows:2534203, index_back_rows:0, output_rows:4781, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[rtm_rp_his_relation], estimation info[table_id:1119302837126301, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:2524359, physical_rc:2524359), (table_type:7, version:1735754400585202-1735754400585202-1735754430995570, logical_rc:0, physical_rc:0), (table_type:7, version:1735754430995570-1735758023561648-1735761610651562, logical_rc:9844, physical_rc:9844), (table_type:5, version:1735754430995570-1735758023561648-1735761610651562, logical_rc:0, physical_rc:0), (table_type:0, version:1735761610651562-1735761610651562-9223372036854775807, logical_rc:0, physical_rc:0)] aaa:table_rows:639673, physical_range_rows:642165, logical_range_rows:642165, index_back_rows:0, output_rows:1621, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[rtm_rp_his_legal], estimation info[table_id:1119302837126299, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:639673, physical_rc:639673), (table_type:7, version:1735754401198088-1735754401198088-1735754431601986, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431601986-1735758023561648-1735761611258918, logical_rc:2492, physical_rc:2492), (table_type:5, version:1735754431601986-1735758023561648-1735761611258918, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611258918-1735761611258918-9223372036854775807, logical_rc:0, physical_rc:0)] r:table_rows:639673, physical_range_rows:642165, logical_range_rows:642165, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[rtm_rp_his_legal], estimation info[table_id:1119302837126299, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:639673, physical_rc:639673), (table_type:7, version:1735754401198088-1735754401198088-1735754431601986, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431601986-1735758023561648-1735761611258918, logical_rc:2492, physical_rc:2492), (table_type:5, version:1735754431601986-1735758023561648-1735761611258918, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611258918-1735761611258918-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] base_ddct:table_rows:409, physical_range_rows:409, logical_range_rows:409, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[base_ddct], estimation info[table_id:1119302837126281, (table_type:1, version:0-1735754410446759-1735754410446759, logical_rc:409, physical_rc:409), (table_type:7, version:1735754401199145-1735754401199145-1735754431603045, logical_rc:0, physical_rc:0), (table_type:7, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:5, version:1735754431603045-1735758023561648-1735761611465802, logical_rc:0, physical_rc:0), (table_type:0, version:1735761611465802-1735761611465802-9223372036854775807, logical_rc:0, physical_rc:0)] Parameters: ------------------------------------- {obj:{"VARCHAR":"eastLegalRpType", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"lpCardType", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"eastLegalCardType", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"eastRelationType", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"domesticState", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"companyNature", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"blocState", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"relationType", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"VARCHAR":"isShareHolding", collation:"utf8mb4_bin", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"VARCHAR", collation:"utf8mb4_bin", coercibility:"INVALID"}}, {obj:{"DECIMAL":"0"}, accuracy:{length:-1, precision:1, scale:0}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"DECIMAL", collation:"binary", coercibility:"NUMERIC"}} -》》》 我的问题是，怎么通过执行计划，看到SQL 慢在哪里。哪一步慢，我知道有全表扫描，但是我不知道全表扫描那一步 是否最慢 -》》 1、explain extended sql 执行计划保存在文本里 发一下 -》已经收集 2、 收集SQL性能问题信息 ->暂时无法收集，因为没有部署 Server version: OceanBase 3.2.4.4 (r104040012023071110-7cfad5c709ba7f8d5f60a8a65cf0d8cb82d99d28) (Built Jul 11 2023 10:52:08) obdiag gather scene run --scene=observer.perf_sql --env “{db_connect=’-hxx -Pxx -uxx -pxx -Dxx’, trace_id=‘xx’}” https://www.oceanbase.com/docs/common-obdiag-cn-1000000001768178 3、使用 DBMS_XPLAN 包配合 sql_audit 查看执行计划。 ->暂时无法收集，因为当前版本是3.2 select /*+ parallel(15) */query_sql,sql_id,svr_ip,TRACE_ID,client_ip,TENANT_NAME,user_name,DB_NAME,ELAPSED_TIME,RET_CODE,FROM_UNIXTIME(ROUND(REQUEST_TIME/1000/1000),’%Y-%m-%d %H:%i:%S’) from GV$OB_SQL_AUDIT WHERE REQUEST_TIME>=‘2024-04-05 14:34:00’ and lower(query_sql) like ‘%select%’; select dbms_xplan.display_cursor('C2FC473F9390B68985F6C3664AC43DBC','all');