+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ================================================================================================================================ | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | -------------------------------------------------------------------------------------------------------------------------------- | | |0 |HASH JOIN | |1 |19913 | | | |1 ||-HASH JOIN | |1 |19492 | | | |2 || |-SUBPLAN SCAN |s1 |1 |19456 | | | |3 || | +-MERGE GROUP BY | |1 |19456 | | | |4 || | +-PARTITION SORT | |1 |19456 | | | |5 || | +-SUBPLAN SCAN |tem |1 |19456 | | | |6 || | +-HASH DISTINCT | |1 |19456 | | | |7 || | +-NESTED-LOOP OUTER JOIN | |1 |19456 | | | |8 || | |-NESTED-LOOP JOIN | |1 |19438 | | | |9 || | | |-NESTED-LOOP JOIN | |1 |19420 | | | |10|| | | | |-HASH OUTER JOIN | |1 |19396 | | | |11|| | | | | |-PX COORDINATOR | |1 |19386 | | | |12|| | | | | | +-EXCHANGE OUT DISTR |:EX10002 |1 |19386 | | | |13|| | | | | | +-MERGE JOIN | |1 |19386 | | | |14|| | | | | | |-SORT | |1 |19374 | | | |15|| | | | | | | +-NESTED-LOOP OUTER JOIN | |1 |19374 | | | |16|| | | | | | | |-NESTED-LOOP OUTER JOIN | |1 |19346 | | | |17|| | | | | | | | |-EXCHANGE IN DISTR | |1 |19325 | | | |18|| | | | | | | | | +-EXCHANGE OUT DISTR (BC2HOST) |:EX10001 |1 |19325 | | | |19|| | | | | | | | | +-NESTED-LOOP JOIN | |1 |19325 | | | |20|| | | | | | | | | |-NESTED-LOOP JOIN | |27 |18847 | | | |21|| | | | | | | | | | |-SUBPLAN SCAN |A |27 |18368 | | | |22|| | | | | | | | | | | +-HASH DISTINCT | |27 |18368 | | | |23|| | | | | | | | | | | +-HASH JOIN | |27 |18354 | | | |24|| | | | | | | | | | | |-EXCHANGE IN DISTR | |1 |156 | | | |25|| | | | | | | | | | | | +-EXCHANGE OUT DISTR |:EX10000 |1 |155 | | | |26|| | | | | | | | | | | | +-SUBPLAN SCAN |b |1 |153 | | | |27|| | | | | | | | | | | | +-WINDOW FUNCTION | |117 |151 | | | |28|| | | | | | | | | | | | +-PARTITION SORT | |117 |50 | | | |29|| | | | | | | | | | | | +-TABLE FULL SCAN|t_identify_task |117 |16 | | | |30|| | | | | | | | | | | +-TABLE FULL SCAN |tem |32644 |3508 | | | |31|| | | | | | | | | | +-DISTRIBUTED TABLE GET |C |1 |18 | | | |32|| | | | | | | | | +-DISTRIBUTED TABLE GET |F |1 |18 | | | |33|| | | | | | | | +-TABLE GET |t1 |1 |21 | | | |34|| | | | | | | +-DISTRIBUTED TABLE RANGE SCAN |m(idx_relationName) |2 |27 | | | |35|| | | | | | +-TABLE RANGE SCAN |D |126 |12 | | | |36|| | | | | +-PX COORDINATOR | |5 |10 | | | |37|| | | | | +-EXCHANGE OUT DISTR |:EX20000 |5 |9 | | | |38|| | | | | +-TABLE FULL SCAN |l |5 |4 | | | |39|| | | | +-DISTRIBUTED TABLE RANGE SCAN |sr(idx_source_id) |2 |23 | | | |40|| | | +-DISTRIBUTED TABLE GET |dai |1 |18 | | | |41|| | +-DISTRIBUTED TABLE GET |t2 |1 |18 | | | |42|| +-PX COORDINATOR | |3 |36 | | | |43|| +-EXCHANGE OUT DISTR |:EX30000 |3 |30 | | | |44|| +-HASH JOIN | |3 |16 | | | |45|| |-SUBPLAN SCAN |b |3 |6 | | | |46|| | +-HASH GROUP BY | |3 |6 | | | |47|| | +-TABLE FULL SCAN |dsp_assets_data_approve_log|10 |5 | | | |48|| +-TABLE FULL SCAN |a |10 |6 | | | |49|+-PX COORDINATOR | |36 |413 | | | |50| +-EXCHANGE OUT DISTR |:EX40000 |36 |290 | | | |51| +-TABLE FULL SCAN |s2 |36 |15 | | | ================================================================================================================================ | | Outputs & filters: | | ------------------------------------- | | 0 - output([s2.areacode(0x7ff29999b690)], [a.relationId(0x7ff29997c8c0)], [UNIX_TIMESTAMP()(0x7ff29999c0a0)], [a.hasModel(0x7ff29997cba0)], ['1'], [s1.areaAssetId(0x7ff29999d5d0)], | | [s1.dataName(0x7ff29999dc30)], [s1.dataLevelId(0x7ff29999e2b0)], [s2.dataCarrierId(0x7ff29999e950)], [a.dataSourceId(0x7ff29997ce80)], [a.dataSourceSystem(0x7ff29997d160)], | | [s1.personalInfo(0x7ff29999fcf0)], [s1.personalInfoType(0x7ff2999a0390)], [s1.infoSystemName(0x7ff2999526f0)], [s1.dataCountGb(0x7ff2999a0dd0)], [s1.dataCountStrip(0x7ff2999a1470)], | | [s2.logicStorageTypeId(0x7ff2999a1b30)], [s1.dbName(0x7ff2999b7ce0)], [s1.dbTable(0x7ff2999b8340)], [s1.description(0x7ff2999b89c0)], [a.saveDeadline(0x7ff29997e2a0)], | | [s2.processorName(0x7ff2999b96e0)], [s2.provinceId(0x7ff2999ba050)], [s2.fullName(0x7ff2999ba6b0)], [s1.phone_number(0x7ff2999bad30)], [a.dataProcessMethodIds(0x7ff29997dce0)], | | [a.dataProcessPurposeId(0x7ff29997dfc0)], [a.automation(0x7ff29997e580)], ['无'], ['无'], ['999'], ['否'], ['无'], ['0'], ['无'], | | ['999'], ['0'], ['0'], ['0'], [s2.infoSystemDomains(0x7ff2999be660)], [s2.safeLevelProtect(0x7ff2999bed00)], [s2.safeRatingRecord(0x7ff2999bf3a0)], [s2.infoSystemTypeId(0x7ff2999bfa40)], | | [s2.infoSystemIps(0x7ff2999c00e0)], [s2.keyFacilities(0x7ff2999c0780)], [s2.safeRiskEvaluation(0x7ff2999c0e40)], [s2.evaluationTime(0x7ff2999c14e0)], [s2.evaluationResult(0x7ff2999c1b80)]), filter(nil), rowset=256 | | equal_conds([s1.infoSystemName(0x7ff2999526f0) = s2.appName(0x7ff2999529e0)(0x7ff299951fa0)]), other_conds(nil) | | 1 - output([a.relationId(0x7ff29997c8c0)], [a.hasModel(0x7ff29997cba0)], [s1.areaAssetId(0x7ff29999d5d0)], [s1.dataName(0x7ff29999dc30)], [s1.dataLevelId(0x7ff29999e2b0)], | | [a.dataSourceId(0x7ff29997ce80)], [a.dataSourceSystem(0x7ff29997d160)], [s1.personalInfo(0x7ff29999fcf0)], [s1.personalInfoType(0x7ff2999a0390)], [s1.infoSystemName(0x7ff2999526f0)], | | [s1.dataCountGb(0x7ff2999a0dd0)], [s1.dataCountStrip(0x7ff2999a1470)], [s1.dbName(0x7ff2999b7ce0)], [s1.dbTable(0x7ff2999b8340)], [s1.description(0x7ff2999b89c0)], | | [a.saveDeadline(0x7ff29997e2a0)], [s1.phone_number(0x7ff2999bad30)], [a.dataProcessMethodIds(0x7ff29997dce0)], [a.dataProcessPurposeId(0x7ff29997dfc0)], | | [a.automation(0x7ff29997e580)]), filter(nil), rowset=256 | | equal_conds([s1.infoSystemName(0x7ff2999526f0) = a.appName(0x7ff29997a7a0)(0x7ff29999a640)]), other_conds(nil) | | 2 - output([s1.areaAssetId(0x7ff29999d5d0)], [s1.dataName(0x7ff29999dc30)], [s1.dataLevelId(0x7ff29999e2b0)], [s1.personalInfo(0x7ff29999fcf0)], [s1.infoSystemName(0x7ff2999526f0)], | | [s1.personalInfoType(0x7ff2999a0390)], [s1.dataCountGb(0x7ff2999a0dd0)], [s1.dataCountStrip(0x7ff2999a1470)], [s1.dbName(0x7ff2999b7ce0)], [s1.dbTable(0x7ff2999b8340)], | | [s1.description(0x7ff2999b89c0)], [s1.phone_number(0x7ff2999bad30)]), filter(nil), rowset=256 | | access([s1.areaAssetId(0x7ff29999d5d0)], [s1.dataName(0x7ff29999dc30)], [s1.dataLevelId(0x7ff29999e2b0)], [s1.personalInfo(0x7ff29999fcf0)], [s1.infoSystemName(0x7ff2999526f0)], | | [s1.personalInfoType(0x7ff2999a0390)], [s1.dataCountGb(0x7ff2999a0dd0)], [s1.dataCountStrip(0x7ff2999a1470)], [s1.dbName(0x7ff2999b7ce0)], [s1.dbTable(0x7ff2999b8340)], | | [s1.description(0x7ff2999b89c0)], [s1.phone_number(0x7ff2999bad30)]) | | 3 - output([tem.areaAssetId(0x7ff299949570)], [T_FUN_GROUP_CONCAT(tem.dataName(0x7ff29994a000))(0x7ff299949920)], [T_FUN_GROUP_CONCAT(tem.dataLevelId(0x7ff29994ab10))(0x7ff29994a430)], | | ['是'], [tem.infoSystemName(0x7ff29994b4c0)], [T_FUN_GROUP_CONCAT(tem.personalInfoType(0x7ff29994bf90))(0x7ff29994b8b0)], [tem.data_countgb(0x7ff29994c670)], | | [tem.data_count(0x7ff29994ccd0)], [tem.dbName(0x7ff29994d310)], [tem.dbTable(0x7ff29994d950)], [tem.description(0x7ff29994dfb0)], [tem.phone_number(0x7ff29994ecb0)]), filter(nil), rowset=256 | | group([tem.areaAssetId(0x7ff299949570)], [tem.dbName(0x7ff29994d310)], [tem.infoSystemName(0x7ff29994b4c0)], [tem.phone_number(0x7ff29994ecb0)], [tem.charge_person(0x7ff29994e630)]), | | agg_func([T_FUN_GROUP_CONCAT(tem.dataName(0x7ff29994a000))(0x7ff299949920)], [T_FUN_GROUP_CONCAT(tem.dataLevelId(0x7ff29994ab10))(0x7ff29994a430)], [T_FUN_GROUP_CONCAT(tem.personalInfoType(0x7ff29994b | | f90))(0x7ff29994b8b0)]) | | 4 - output([tem.areaAssetId(0x7ff299949570)], [tem.dbName(0x7ff29994d310)], [tem.infoSystemName(0x7ff29994b4c0)], [tem.phone_number(0x7ff29994ecb0)], | | [tem.charge_person(0x7ff29994e630)], [tem.data_countgb(0x7ff29994c670)], [tem.data_count(0x7ff29994ccd0)], [tem.dbTable(0x7ff29994d950)], [tem.description(0x7ff29994dfb0)], | | [tem.dataName(0x7ff29994a000)], [tem.dataLevelId(0x7ff29994ab10)], [tem.personalInfoType(0x7ff29994bf90)]), filter(nil), rowset=256 | | sort_keys([HASH(tem.areaAssetId(0x7ff299949570), tem.dbName(0x7ff29994d310), tem.infoSystemName(0x7ff29994b4c0), tem.phone_number(0x7ff29994ecb0), | | tem.charge_person(0x7ff29994e630))(0x7ff2ac841870), ASC], [tem.areaAssetId(0x7ff299949570), ASC], [tem.dbName(0x7ff29994d310), ASC], [tem.infoSystemName(0x7ff29994b4c0), | | ASC], [tem.phone_number(0x7ff29994ecb0), ASC], [tem.charge_person(0x7ff29994e630), ASC]) | | 5 - output([tem.areaAssetId(0x7ff299949570)], [tem.dataName(0x7ff29994a000)], [tem.dataLevelId(0x7ff29994ab10)], [tem.infoSystemName(0x7ff29994b4c0)], | | [tem.personalInfoType(0x7ff29994bf90)], [tem.data_countgb(0x7ff29994c670)], [tem.data_count(0x7ff29994ccd0)], [tem.dbName(0x7ff29994d310)], [tem.dbTable(0x7ff29994d950)], | | [tem.description(0x7ff29994dfb0)], [tem.charge_person(0x7ff29994e630)], [tem.phone_number(0x7ff29994ecb0)]), filter(nil), rowset=256 | | access([tem.areaAssetId(0x7ff299949570)], [tem.dataName(0x7ff29994a000)], [tem.dataLevelId(0x7ff29994ab10)], [tem.infoSystemName(0x7ff29994b4c0)], | | [tem.personalInfoType(0x7ff29994bf90)], [tem.data_countgb(0x7ff29994c670)], [tem.data_count(0x7ff29994ccd0)], [tem.dbName(0x7ff29994d310)], [tem.dbTable(0x7ff29994d950)], | | [tem.description(0x7ff29994dfb0)], [tem.charge_person(0x7ff29994e630)], [tem.phone_number(0x7ff29994ecb0)]) | | 6 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], | | [ifnull(m.code(0x7ff299942950), cast('5', VARCHAR(255))(0x7ff299947960))(0x7ff299941b00)], [t2.business_name(0x7ff299933d20)], [l.name(0x7ff2999455a0)], | | [dai.app_name(0x7ff2998f7fe0)], [dai.charge_person(0x7ff2998f4050)], [F.data_countgb(0x7ff2998f4d50)], [dai.phone_number(0x7ff2998f7300)]), filter(nil), rowset=256 | | distinct([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [ifnull(m.code(0x7ff299942950), cast('5', VARCHAR(255))(0x7ff299947960))(0x7ff299941b00)], | | [t2.business_name(0x7ff299933d20)], [l.name(0x7ff2999455a0)], [dai.app_name(0x7ff2998f7fe0)], [dai.charge_person(0x7ff2998f4050)], [dai.phone_number(0x7ff2998f7300)]) | | 7 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [t2.business_name(0x7ff299933d20)], [l.name(0x7ff2999455a0)], [dai.app_name(0x7ff2998f7fe0)], | | [dai.charge_person(0x7ff2998f4050)], [dai.phone_number(0x7ff2998f7300)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], | | [F.data_countgb(0x7ff2998f4d50)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | conds(nil), nl_params_([t1.parent_id(0x7ff299900690)(:33)]), use_batch=true | | 8 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [l.name(0x7ff2999455a0)], [dai.app_name(0x7ff2998f7fe0)], [dai.charge_person(0x7ff2998f4050)], | | [dai.phone_number(0x7ff2998f7300)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [t1.parent_id(0x7ff299900690)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | conds(nil), nl_params_([sr.app_id(0x7ff2998e5df0)(:24)]), use_batch=true | | 9 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [l.name(0x7ff2999455a0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], | | [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], [t1.parent_id(0x7ff299900690)], [sr.app_id(0x7ff2998e5df0)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | conds(nil), nl_params_([A.source_id(0x7ff2998f97a0)(:4)]), use_batch=true | | 10 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [l.name(0x7ff2999455a0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], | | [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | equal_conds([t1.level_id(0x7ff299916330) = l.id(0x7ff29993bf30)(0x7ff29993b4f0)]), other_conds(nil) | | 11 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], | | [F.data_countgb(0x7ff2998f4d50)], [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [t1.level_id(0x7ff299916330)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | 12 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], | | [F.data_countgb(0x7ff2998f4d50)], [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [t1.level_id(0x7ff299916330)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | is_single, dop=1 | | 13 - output([F.id(0x7ff2998ee6c0)], [D.default_schema(0x7ff2998f3760)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], | | [F.data_countgb(0x7ff2998f4d50)], [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [t1.level_id(0x7ff299916330)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | equal_conds([A.source_id(0x7ff2998f97a0) = D.id(0x7ff2998e98d0)(0x7ff272b14ee0)]), other_conds(nil) | | merge_directions([ASC]) | | 14 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [t1.level_id(0x7ff299916330)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | sort_keys([A.source_id(0x7ff2998f97a0), ASC]) | | 15 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [t1.level_id(0x7ff299916330)], [m.code(0x7ff299942950)]), filter(nil), rowset=256 | | conds(nil), nl_params_([t1.business_name(0x7ff299902880)(:35)]), use_batch=true | | 16 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [t1.parent_id(0x7ff299900690)], [A.source_id(0x7ff2998f97a0)], [t1.business_name(0x7ff299902880)], [t1.level_id(0x7ff299916330)]), filter(nil), rowset=256 | | conds(nil), nl_params_([A.identify_business_id(0x7ff299938cd0)(:22)]), use_batch=false | | 17 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [A.source_id(0x7ff2998f97a0)], [A.identify_business_id(0x7ff299938cd0)]), filter(nil), rowset=256 | | 18 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [A.source_id(0x7ff2998f97a0)], [A.identify_business_id(0x7ff299938cd0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 19 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)], | | [A.source_id(0x7ff2998f97a0)], [A.identify_business_id(0x7ff299938cd0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([A.source_id(0x7ff2998f97a0)(:38)], [A.table_id(0x7ff2998fb060)(:39)], [C.table_id(0x7ff2998ee3d0)(:40)]), use_batch=true | | 20 - output([A.source_id(0x7ff2998f97a0)], [A.identify_business_id(0x7ff299938cd0)], [A.table_id(0x7ff2998fb060)], [C.table_id(0x7ff2998ee3d0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([A.field_id(0x7ff2998fc630)(:16)]), use_batch=true | | 21 - output([A.source_id(0x7ff2998f97a0)], [A.table_id(0x7ff2998fb060)], [A.field_id(0x7ff2998fc630)], [A.identify_business_id(0x7ff299938cd0)]), filter(nil), rowset=256 | | access([A.source_id(0x7ff2998f97a0)], [A.table_id(0x7ff2998fb060)], [A.field_id(0x7ff2998fc630)], [A.identify_business_id(0x7ff299938cd0)]) | | 22 - output([tem.identify_business_id(0x7ff2c142e0b0)], [tem.source_id(0x7ff2c142ddd0)], [tem.table_id(0x7ff2c142e390)], [tem.field_id(0x7ff2c142e670)]), filter(nil), rowset=256 | | distinct([tem.identify_business_id(0x7ff2c142e0b0)], [tem.source_id(0x7ff2c142ddd0)], [tem.table_id(0x7ff2c142e390)], [tem.field_id(0x7ff2c142e670)]) | | 23 - output([tem.identify_business_id(0x7ff2c142e0b0)], [tem.source_id(0x7ff2c142ddd0)], [tem.table_id(0x7ff2c142e390)], [tem.field_id(0x7ff2c142e670)]), filter(nil), rowset=256 | | equal_conds([tem.task_id(0x7ff2c142daf0) = b.t_identify_task.id(0x7ff2c1432c80)(0x7ff2c142f7b0)], [b.source_id(0x7ff2c142f4d0) = tem.source_id(0x7ff2c142ddd0)(0x7ff2c1430040)]), | | other_conds(nil) | | 24 - output([b.source_id(0x7ff2c142f4d0)], [b.t_identify_task.id(0x7ff2c1432c80)]), filter(nil), rowset=256 | | 25 - output([b.source_id(0x7ff2c142f4d0)], [b.t_identify_task.id(0x7ff2c1432c80)]), filter(nil), rowset=256 | | is_single, dop=1 | | 26 - output([b.source_id(0x7ff2c142f4d0)], [b.t_identify_task.id(0x7ff2c1432c80)]), filter([b.t_identify_task.update_time(0x7ff2c1432f80) = b.maxtime(0x7ff2c142ef10)(0x7ff2c14308d0)]), rowset=256 | | access([b.maxtime(0x7ff2c142ef10)], [b.source_id(0x7ff2c142f4d0)], [b.t_identify_task.id(0x7ff2c1432c80)], [b.t_identify_task.update_time(0x7ff2c1432f80)]) | | 27 - output([T_FUN_MAX(t_identify_task.update_time(0x7ff2c14322f0))(0x7ff2c14328b0)(0x7ff2c1458050)], [t_identify_task.source_id(0x7ff2c14325d0)], [t_identify_task.id(0x7ff2c1432010)], | | [t_identify_task.update_time(0x7ff2c14322f0)]), filter(nil), rowset=256 | | win_expr(T_FUN_MAX(t_identify_task.update_time(0x7ff2c14322f0))(0x7ff2c14328b0)(0x7ff2c1458050)), partition_by([t_identify_task.source_id(0x7ff2c14325d0)]), | | order_by(nil), window_type(RANGE), upper(UNBOUNDED PRECEDING), lower(UNBOUNDED FOLLOWING) | | 28 - output([t_identify_task.source_id(0x7ff2c14325d0)], [t_identify_task.id(0x7ff2c1432010)], [t_identify_task.update_time(0x7ff2c14322f0)]), filter(nil), rowset=256 | | sort_keys([HASH(t_identify_task.source_id(0x7ff2c14325d0))(0x7ff272bcb190), ASC], [t_identify_task.source_id(0x7ff2c14325d0), ASC]) | | 29 - output([t_identify_task.id(0x7ff2c1432010)], [t_identify_task.update_time(0x7ff2c14322f0)], [t_identify_task.source_id(0x7ff2c14325d0)]), filter([t_identify_task.source_id(0x7ff2c14325d0) | | != cast('', VARCHAR(1048576))(0x7ff2998efbb0)(0x7ff289f37cc0)]), rowset=256 | | access([t_identify_task.id(0x7ff2c1432010)], [t_identify_task.update_time(0x7ff2c14322f0)], [t_identify_task.source_id(0x7ff2c14325d0)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([t_identify_task.id(0x7ff2c1432010)]), range(MIN ; MAX)always true | | 30 - output([tem.task_id(0x7ff2c142daf0)], [tem.source_id(0x7ff2c142ddd0)], [tem.identify_business_id(0x7ff2c142e0b0)], [tem.table_id(0x7ff2c142e390)], | | [tem.field_id(0x7ff2c142e670)]), filter([tem.source_id(0x7ff2c142ddd0) != cast('', VARCHAR(1048576))(0x7ff2998efbb0)(0x7ff2b7a0c380)]), rowset=256 | | access([tem.task_id(0x7ff2c142daf0)], [tem.source_id(0x7ff2c142ddd0)], [tem.identify_business_id(0x7ff2c142e0b0)], [tem.table_id(0x7ff2c142e390)], | | [tem.field_id(0x7ff2c142e670)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([tem.id(0x7ff2c142d810)]), range(MIN ; MAX)always true | | 31 - output([C.table_id(0x7ff2998ee3d0)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff2ac9ebc90)], [C.table_id(0x7ff2998ee3d0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([C.id(0x7ff2998f1dc0)]), range(MIN ; MAX), | | range_cond([C.id(0x7ff2998f1dc0) = :16(0x7ff2b7becd80)]) | | 32 - output([F.id(0x7ff2998ee6c0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], [F.data_countgb(0x7ff2998f4d50)]), filter([:38 | | = F.source_id(0x7ff2998eaed0)(0x7ff2a8ed7b90)], [F.source_id(0x7ff2998eaed0) != cast('', VARCHAR(1048576))(0x7ff2998efbb0)(0x7ff2b7a0b060)]), rowset=256 | | access([GROUP_ID(0x7ff2ac9ebee0)], [F.id(0x7ff2998ee6c0)], [F.source_id(0x7ff2998eaed0)], [F.name(0x7ff2998f1140)], [F.notes(0x7ff2998f1780)], [F.data_count(0x7ff2998f46d0)], | | [F.data_countgb(0x7ff2998f4d50)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false,false], | | range_key([F.id(0x7ff2998ee6c0)]), range(MIN ; MAX), | | range_cond([F.id(0x7ff2998ee6c0) = :39(0x7ff2a8ed86f0)], [:40 = F.id(0x7ff2998ee6c0)(0x7ff2a8ed9250)]) | | 33 - output([t1.parent_id(0x7ff299900690)], [t1.business_name(0x7ff299902880)], [t1.level_id(0x7ff299916330)]), filter(nil), rowset=256 | | access([t1.parent_id(0x7ff299900690)], [t1.business_name(0x7ff299902880)], [t1.level_id(0x7ff299916330)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([t1.id(0x7ff2999025a0)]), range(MIN ; MAX), | | range_cond([cast(:22, DECIMAL(-1, -1))(0x7ff299507ca0) = cast(t1.id(0x7ff2999025a0), DECIMAL(11, 0))(0x7ff29993a080)(0x7ff299508540)]) | | 34 - output([m.code(0x7ff299942950)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff2ac9f1e60)], [m.id(0x7ff2999c6130)], [m.code(0x7ff299942950)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([m.relationName(0x7ff29993f720)], [m.id(0x7ff2999c6130)]), range(MIN ; MAX), | | range_cond([:35 = m.relationName(0x7ff29993f720)(0x7ff2a8e1ece0)]) | | 35 - output([D.id(0x7ff2998e98d0)], [D.default_schema(0x7ff2998f3760)]), filter(nil), rowset=256 | | access([D.id(0x7ff2998e98d0)], [D.default_schema(0x7ff2998f3760)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([D.id(0x7ff2998e98d0)]), range(NULL ; ), ( ; MAX), | | range_cond([D.id(0x7ff2998e98d0) != cast('', VARCHAR(1048576))(0x7ff2998efbb0)(0x7ff2b7a0b9f0)]) | | 36 - output([l.name(0x7ff2999455a0)], [l.id(0x7ff29993bf30)]), filter(nil), rowset=256 | | 37 - output([l.name(0x7ff2999455a0)], [l.id(0x7ff29993bf30)]), filter(nil), rowset=256 | | is_single, dop=1 | | 38 - output([l.id(0x7ff29993bf30)], [l.name(0x7ff2999455a0)]), filter(nil), rowset=256 | | access([l.id(0x7ff29993bf30)], [l.name(0x7ff2999455a0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([l.id(0x7ff29993bf30)]), range(MIN ; MAX)always true | | 39 - output([sr.app_id(0x7ff2998e5df0)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff28140dba0)], [sr.id(0x7ff2999c50c0)], [sr.app_id(0x7ff2998e5df0)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([sr.source_id(0x7ff2998e95e0)], [sr.id(0x7ff2999c50c0)]), range(MIN ; MAX), | | range_cond([sr.source_id(0x7ff2998e95e0) != cast('', VARCHAR(1048576))(0x7ff2998efbb0)(0x7ff2998ef1d0)], [:4 = sr.source_id(0x7ff2998e95e0)(0x7ff2b7aa44f0)]) | | 40 - output([dai.charge_person(0x7ff2998f4050)], [dai.phone_number(0x7ff2998f7300)], [dai.app_name(0x7ff2998f7fe0)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff28140fd00)], [dai.charge_person(0x7ff2998f4050)], [dai.phone_number(0x7ff2998f7300)], [dai.app_name(0x7ff2998f7fe0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([dai.id(0x7ff2998e60e0)]), range(MIN ; MAX), | | range_cond([:24 = dai.id(0x7ff2998e60e0)(0x7ff29951a210)]) | | 41 - output([t2.business_name(0x7ff299933d20)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff281413d70)], [t2.business_name(0x7ff299933d20)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([t2.id(0x7ff299900980)]), range(MIN ; MAX), | | range_cond([cast(:33, DECIMAL(-1, -1))(0x7ff2995f7a10) = cast(t2.id(0x7ff299900980), DECIMAL(11, 0))(0x7ff299901a40)(0x7ff2995f82b0)]) | | 42 - output([a.relationId(0x7ff29997c8c0)], [a.hasModel(0x7ff29997cba0)], [a.dataSourceId(0x7ff29997ce80)], [a.dataSourceSystem(0x7ff29997d160)], [a.saveDeadline(0x7ff29997e2a0)], | | [a.dataProcessMethodIds(0x7ff29997dce0)], [a.dataProcessPurposeId(0x7ff29997dfc0)], [a.automation(0x7ff29997e580)], [a.appName(0x7ff29997a7a0)]), filter(nil), rowset=256 | | 43 - output([a.relationId(0x7ff29997c8c0)], [a.hasModel(0x7ff29997cba0)], [a.dataSourceId(0x7ff29997ce80)], [a.dataSourceSystem(0x7ff29997d160)], [a.saveDeadline(0x7ff29997e2a0)], | | [a.dataProcessMethodIds(0x7ff29997dce0)], [a.dataProcessPurposeId(0x7ff29997dfc0)], [a.automation(0x7ff29997e580)], [a.appName(0x7ff29997a7a0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 44 - output([a.relationId(0x7ff29997c8c0)], [a.hasModel(0x7ff29997cba0)], [a.dataSourceId(0x7ff29997ce80)], [a.dataSourceSystem(0x7ff29997d160)], [a.saveDeadline(0x7ff29997e2a0)], | | [a.dataProcessMethodIds(0x7ff29997dce0)], [a.dataProcessPurposeId(0x7ff29997dfc0)], [a.automation(0x7ff29997e580)], [a.appName(0x7ff29997a7a0)]), filter(nil), rowset=256 | | equal_conds([a.appName(0x7ff29997a7a0) = b.appName(0x7ff29997aa90)(0x7ff29997a050)], [a.updatedTime(0x7ff29997bd70) = b.lastTime(0x7ff29997c060)(0x7ff29997b620)]), | | other_conds(nil) | | 45 - output([b.appName(0x7ff29997aa90)], [b.lastTime(0x7ff29997c060)]), filter(nil), rowset=256 | | access([b.appName(0x7ff29997aa90)], [b.lastTime(0x7ff29997c060)]) | | 46 - output([dsp_assets_data_approve_log.appName(0x7ff299954460)], [T_FUN_MAX(dsp_assets_data_approve_log.updatedTime(0x7ff299954ed0))(0x7ff2999547f0)]), filter(nil), rowset=256 | | group([dsp_assets_data_approve_log.appName(0x7ff299954460)]), agg_func([T_FUN_MAX(dsp_assets_data_approve_log.updatedTime(0x7ff299954ed0))(0x7ff2999547f0)]) | | 47 - output([dsp_assets_data_approve_log.appName(0x7ff299954460)], [dsp_assets_data_approve_log.updatedTime(0x7ff299954ed0)]), filter(nil), rowset=256 | | access([dsp_assets_data_approve_log.appName(0x7ff299954460)], [dsp_assets_data_approve_log.updatedTime(0x7ff299954ed0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([dsp_assets_data_approve_log.id(0x7ff2999c9650)]), range(MIN ; MAX)always true | | 48 - output([a.appName(0x7ff29997a7a0)], [a.updatedTime(0x7ff29997bd70)], [a.relationId(0x7ff29997c8c0)], [a.hasModel(0x7ff29997cba0)], [a.dataSourceId(0x7ff29997ce80)], | | [a.dataSourceSystem(0x7ff29997d160)], [a.dataProcessMethodIds(0x7ff29997dce0)], [a.dataProcessPurposeId(0x7ff29997dfc0)], [a.saveDeadline(0x7ff29997e2a0)], | | [a.automation(0x7ff29997e580)]), filter(nil), rowset=256 | | access([a.appName(0x7ff29997a7a0)], [a.updatedTime(0x7ff29997bd70)], [a.relationId(0x7ff29997c8c0)], [a.hasModel(0x7ff29997cba0)], [a.dataSourceId(0x7ff29997ce80)], | | [a.dataSourceSystem(0x7ff29997d160)], [a.dataProcessMethodIds(0x7ff29997dce0)], [a.dataProcessPurposeId(0x7ff29997dfc0)], [a.saveDeadline(0x7ff29997e2a0)], | | [a.automation(0x7ff29997e580)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([a.id(0x7ff29997c5e0)]), range(MIN ; MAX)always true | | 49 - output([s2.areacode(0x7ff29999b690)], [s2.dataCarrierId(0x7ff29999e950)], [s2.logicStorageTypeId(0x7ff2999a1b30)], [s2.processorName(0x7ff2999b96e0)], | | [s2.provinceId(0x7ff2999ba050)], [s2.fullName(0x7ff2999ba6b0)], [s2.infoSystemDomains(0x7ff2999be660)], [s2.safeLevelProtect(0x7ff2999bed00)], [s2.safeRatingRecord(0x7ff2999bf3a0)], | | [s2.infoSystemTypeId(0x7ff2999bfa40)], [s2.infoSystemIps(0x7ff2999c00e0)], [s2.keyFacilities(0x7ff2999c0780)], [s2.safeRiskEvaluation(0x7ff2999c0e40)], | | [s2.evaluationTime(0x7ff2999c14e0)], [s2.evaluationResult(0x7ff2999c1b80)], [s2.appName(0x7ff2999529e0)]), filter(nil), rowset=256 | | 50 - output([s2.areacode(0x7ff29999b690)], [s2.dataCarrierId(0x7ff29999e950)], [s2.logicStorageTypeId(0x7ff2999a1b30)], [s2.processorName(0x7ff2999b96e0)], | | [s2.provinceId(0x7ff2999ba050)], [s2.fullName(0x7ff2999ba6b0)], [s2.infoSystemDomains(0x7ff2999be660)], [s2.safeLevelProtect(0x7ff2999bed00)], [s2.safeRatingRecord(0x7ff2999bf3a0)], | | [s2.infoSystemTypeId(0x7ff2999bfa40)], [s2.infoSystemIps(0x7ff2999c00e0)], [s2.keyFacilities(0x7ff2999c0780)], [s2.safeRiskEvaluation(0x7ff2999c0e40)], | | [s2.evaluationTime(0x7ff2999c14e0)], [s2.evaluationResult(0x7ff2999c1b80)], [s2.appName(0x7ff2999529e0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 51 - output([s2.appName(0x7ff2999529e0)], [s2.areacode(0x7ff29999b690)], [s2.dataCarrierId(0x7ff29999e950)], [s2.logicStorageTypeId(0x7ff2999a1b30)], [s2.processorName(0x7ff2999b96e0)], | | [s2.provinceId(0x7ff2999ba050)], [s2.fullName(0x7ff2999ba6b0)], [s2.infoSystemDomains(0x7ff2999be660)], [s2.safeLevelProtect(0x7ff2999bed00)], [s2.safeRatingRecord(0x7ff2999bf3a0)], | | [s2.infoSystemTypeId(0x7ff2999bfa40)], [s2.infoSystemIps(0x7ff2999c00e0)], [s2.keyFacilities(0x7ff2999c0780)], [s2.safeRiskEvaluation(0x7ff2999c0e40)], | | [s2.evaluationTime(0x7ff2999c14e0)], [s2.evaluationResult(0x7ff2999c1b80)]), filter(nil), rowset=256 | | access([s2.appName(0x7ff2999529e0)], [s2.areacode(0x7ff29999b690)], [s2.dataCarrierId(0x7ff29999e950)], [s2.logicStorageTypeId(0x7ff2999a1b30)], [s2.processorName(0x7ff2999b96e0)], | | [s2.provinceId(0x7ff2999ba050)], [s2.fullName(0x7ff2999ba6b0)], [s2.infoSystemDomains(0x7ff2999be660)], [s2.safeLevelProtect(0x7ff2999bed00)], [s2.safeRatingRecord(0x7ff2999bf3a0)], | | [s2.infoSystemTypeId(0x7ff2999bfa40)], [s2.infoSystemIps(0x7ff2999c00e0)], [s2.keyFacilities(0x7ff2999c0780)], [s2.safeRiskEvaluation(0x7ff2999c0e40)], | | [s2.evaluationTime(0x7ff2999c14e0)], [s2.evaluationResult(0x7ff2999c1b80)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([s2.id(0x7ff299844050)]), range(MIN ; MAX)always true | | Used Hint: | | ------------------------------------- | | /*+ | | | | */ | | Qb name trace: | | ------------------------------------- | | stmt_id:0, stmt_type:T_EXPLAIN | | stmt_id:1, SEL$1 > SEL$3D2404FF > SEL$659CB5A9 | | stmt_id:2, SEL$2 > SEL$2F8A4177 | | stmt_id:3, SEL$3 > SEL$70B51D94 > SEL$61E81FFB > SEL$49D1E181 | | stmt_id:4, SEL$4 > SEL$271161F2 > SEL$03383B01 > SEL$44AED776 > SEL$C0C768F5 > SEL$49D1E182 | | stmt_id:5, SEL$5 > SEL$3FC86D63 > SEL$79212DFB | | stmt_id:6, SEL$6 > SEL$7467AFC1 > SEL$C0290405 > SEL$8D518009 > SEL$27A1275B | | stmt_id:7, SEL$7 > SEL$341AAD84 | | stmt_id:8, SEL$8 > SEL$E9D4444A | | stmt_id:9, SEL$9 > SEL$FFA30D18 | | stmt_id:10, SEL$10 | | Outline Data: | | ------------------------------------- | | /*+ | | BEGIN_OUTLINE_DATA | | LEADING(@"SEL$659CB5A9" (("s1"@"SEL$1" ("b"@"SEL$9" "db1"."a"@"SEL$9")) "db1"."s2"@"SEL$1")) | | USE_HASH(@"SEL$659CB5A9" "db1"."s2"@"SEL$1") | | PQ_DISTRIBUTE(@"SEL$659CB5A9" "db1"."s2"@"SEL$1" LOCAL LOCAL) | | USE_HASH(@"SEL$659CB5A9" ("b"@"SEL$9" "db1"."a"@"SEL$9")) | | PQ_DISTRIBUTE(@"SEL$659CB5A9" ("b"@"SEL$9" "db1"."a"@"SEL$9") LOCAL LOCAL) | | NO_USE_HASH_AGGREGATION(@"SEL$2F8A4177" PARTITION_SORT) | | USE_HASH_DISTINCT(@"SEL$49D1E181") | | LEADING(@"SEL$49D1E181" ((((((((("A"@"SEL$3" "db1"."C"@"SEL$7") "db1"."F"@"SEL$7") "db1"."t1"@"SEL$8") "db1"."m"@"SEL$3") "db1"."D"@"SEL$7") "db1"."l"@"SEL$3") "db1"."sr"@"SEL$7") "db1"."dai"@"SEL$7") "db1"."t2"@"SEL$8")) | | USE_NL(@"SEL$49D1E181" "db1"."t2"@"SEL$8") | | USE_NL(@"SEL$49D1E181" "db1"."dai"@"SEL$7") | | USE_NL(@"SEL$49D1E181" "db1"."sr"@"SEL$7") | | USE_HASH(@"SEL$49D1E181" "db1"."l"@"SEL$3") | | PQ_DISTRIBUTE(@"SEL$49D1E181" "db1"."l"@"SEL$3" LOCAL LOCAL) | | USE_MERGE(@"SEL$49D1E181" "db1"."D"@"SEL$7") | | USE_NL(@"SEL$49D1E181" "db1"."m"@"SEL$3") | | USE_NL(@"SEL$49D1E181" "db1"."t1"@"SEL$8") | | PQ_DISTRIBUTE(@"SEL$49D1E181" "db1"."t1"@"SEL$8" BC2HOST NONE) | | USE_NL(@"SEL$49D1E181" "db1"."F"@"SEL$7") | | USE_NL(@"SEL$49D1E181" "db1"."C"@"SEL$7") | | USE_HASH_DISTINCT(@"SEL$49D1E182") | | LEADING(@"SEL$49D1E182" ("b"@"SEL$5" "db1"."tem"@"SEL$4")) | | USE_HASH(@"SEL$49D1E182" "db1"."tem"@"SEL$4") | | PQ_DISTRIBUTE(@"SEL$49D1E182" "db1"."tem"@"SEL$4" LOCAL LOCAL) | | PQ_DISTRIBUTE_WINDOW(@"SEL$27A1275B" (0) NONE PARTITION_SORT) | | FULL(@"SEL$27A1275B" "db1"."t_identify_task"@"SEL$6") | | FULL(@"SEL$49D1E182" "tem"@"SEL$4") | | FULL(@"SEL$49D1E181" "C"@"SEL$7") | | USE_DAS(@"SEL$49D1E181" "C"@"SEL$7") | | FULL(@"SEL$49D1E181" "F"@"SEL$7") | | USE_DAS(@"SEL$49D1E181" "F"@"SEL$7") | | FULL(@"SEL$49D1E181" "t1"@"SEL$8") | | INDEX(@"SEL$49D1E181" "m"@"SEL$3" "idx_relationName") | | USE_DAS(@"SEL$49D1E181" "m"@"SEL$3") | | FULL(@"SEL$49D1E181" "D"@"SEL$7") | | FULL(@"SEL$49D1E181" "l"@"SEL$3") | | INDEX(@"SEL$49D1E181" "sr"@"SEL$7" "idx_source_id") | | USE_DAS(@"SEL$49D1E181" "sr"@"SEL$7") | | FULL(@"SEL$49D1E181" "dai"@"SEL$7") | | USE_DAS(@"SEL$49D1E181" "dai"@"SEL$7") | | FULL(@"SEL$49D1E181" "t2"@"SEL$8") | | USE_DAS(@"SEL$49D1E181" "t2"@"SEL$8") | | USE_HASH(@"SEL$659CB5A9" "db1"."a"@"SEL$9") | | USE_HASH_AGGREGATION(@"SEL$10") | | FULL(@"SEL$10" "db1"."dsp_assets_data_approve_log"@"SEL$10") | | FULL(@"SEL$659CB5A9" "a"@"SEL$9") | | FULL(@"SEL$659CB5A9" "s2"@"SEL$1") | | SIMPLIFY_DISTINCT(@"SEL$6") | | SIMPLIFY_DISTINCT(@"SEL$5") | | PROJECT_PRUNE(@"SEL$2") | | PROJECT_PRUNE(@"SEL$9") | | PROJECT_PRUNE(@"SEL$7") | | PROJECT_PRUNE(@"SEL$8") | | PROJECT_PRUNE(@"SEL$3FC86D63") | | MERGE(@"SEL$79212DFB" > "SEL$4") | | MERGE(@"SEL$341AAD84" > "SEL$3") | | MERGE(@"SEL$E9D4444A" > "SEL$3") | | MERGE(@"SEL$FFA30D18" > "SEL$1") | | OUTER_TO_INNER(@"SEL$271161F2") | | OUTER_TO_INNER(@"SEL$70B51D94") | | OUTER_TO_INNER(@"SEL$3D2404FF") | | WIN_MAGIC(@"SEL$03383B01" "b"@"SEL$5" "db1"."a"@"SEL$5") | | PRED_DEDUCE(@"SEL$61E81FFB") | | PRED_DEDUCE(@"SEL$44AED776") | | PRED_DEDUCE(@"SEL$7467AFC1") | | SIMPLIFY_EXPR(@"SEL$C0290405") | | PRED_DEDUCE(@"SEL$C0C768F5") | | PRED_DEDUCE(@"SEL$8D518009") | | OPTIMIZER_FEATURES_ENABLE('4.2.1.7') | | END_OUTLINE_DATA | | */ | | Optimization Info: | | ------------------------------------- | | t_identify_task: | | table_rows:121 | | physical_range_rows:121 | | logical_range_rows:121 | | index_back_rows:0 | | output_rows:116 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[t_identify_task] | | stats version:1742958168243444 | | dynamic sampling level:0 | | tem: | | table_rows:34362 | | physical_range_rows:34362 | | logical_range_rows:34362 | | index_back_rows:0 | | output_rows:32643 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[indx_fd_id, indx_tb_id, t_identify_record] | | stats version:1742958167965004 | | dynamic sampling level:0 | | C: | | table_rows:773798 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:DAS DOP | | avaiable_index_name:[idx_source_id, idx_table_id, t_collect_field_info] | | pruned_index_name:[idx_source_id, idx_table_id] | | stats version:1742958176598536 | | dynamic sampling level:0 | | F: | | table_rows:26089 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:0 | | table_dop:1 | | dop_method:DAS DOP | | avaiable_index_name:[idx_source_id, t_collect_table_info] | | pruned_index_name:[idx_source_id] | | stats version:1742958169534235 | | dynamic sampling level:0 | | t1: | | table_rows:479 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_parent_id, dim_business_info] | | pruned_index_name:[idx_parent_id] | | stats version:1742958168478900 | | dynamic sampling level:0 | | m: | | table_rows:103 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:1 | | output_rows:1 | | table_dop:1 | | dop_method:DAS DOP | | avaiable_index_name:[idx_relationName, dsp_assets_data_code_info] | | unstable_index_name:[dsp_assets_data_code_info] | | stats version:1742958168713886 | | dynamic sampling level:0 | | D: | | table_rows:126 | | physical_range_rows:126 | | logical_range_rows:126 | | index_back_rows:0 | | output_rows:126 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[t_collect_source_info] | | stats version:1742958169314866 | | dynamic sampling level:0 | | l: | | table_rows:5 | | physical_range_rows:5 | | logical_range_rows:5 | | index_back_rows:0 | | output_rows:5 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[dim_level_info] | | stats version:1742958168614753 | | dynamic sampling level:0 | | sr: | | table_rows:92 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:1 | | output_rows:1 | | table_dop:1 | | dop_method:DAS DOP | | avaiable_index_name:[idx_source_id, dim_app_source_relation] | | unstable_index_name:[dim_app_source_relation] | | stats version:1742958169199156 | | dynamic sampling level:0 | | dai: | | table_rows:60 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:DAS DOP | | avaiable_index_name:[dim_app_info] | | stats version:1742958168353201 | | dynamic sampling level:0 | | t2: | | table_rows:479 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:0 | | output_rows:1 | | table_dop:1 | | dop_method:DAS DOP | | avaiable_index_name:[idx_parent_id, dim_business_info] | | pruned_index_name:[idx_parent_id] | | stats version:1742958168478900 | | dynamic sampling level:0 | | dsp_assets_data_approve_log: | | table_rows:10 | | physical_range_rows:10 | | logical_range_rows:10 | | index_back_rows:0 | | output_rows:10 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[dsp_assets_data_approve_log] | | stats version:1742958169134947 | | dynamic sampling level:0 | | a: | | table_rows:10 | | physical_range_rows:10 | | logical_range_rows:10 | | index_back_rows:0 | | output_rows:10 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[dsp_assets_data_approve_log] | | stats version:1742958169134947 | | dynamic sampling level:0 | | s2: | | table_rows:36 | | physical_range_rows:36 | | logical_range_rows:36 | | index_back_rows:0 | | output_rows:36 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[dsp_sys_assets_data_info] | | stats version:1742958169029116 | | dynamic sampling level:0 | | Plan Type: | | DISTRIBUTED | | Note: | | Degree of Parallelisim is 1 because of table property | | Expr Constraints: | | 1 result is TRUE | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+