+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ================================================================================================================= | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | ----------------------------------------------------------------------------------------------------------------- | | |0 |HASH JOIN | |35 |90834 | | | |1 ||-HASH JOIN | |3 |459 | | | |2 || |-PX COORDINATOR | |3 |36 | | | |3 || | +-EXCHANGE OUT DISTR |:EX10000 |3 |30 | | | |4 || | +-HASH JOIN | |3 |16 | | | |5 || | |-SUBPLAN SCAN |b |3 |6 | | | |6 || | | +-HASH GROUP BY | |3 |6 | | | |7 || | | +-TABLE FULL SCAN |dsp_assets_data_approve_log|10 |5 | | | |8 || | +-TABLE FULL SCAN |a |10 |6 | | | |9 || +-PX COORDINATOR | |36 |413 | | | |10|| +-EXCHANGE OUT DISTR |:EX20000 |36 |290 | | | |11|| +-TABLE FULL SCAN |s2 |36 |15 | | | |12|+-SUBPLAN SCAN |s1 |682 |90189 | | | |13| +-MERGE GROUP BY | |682 |90187 | | | |14| +-PARTITION SORT | |682 |89204 | | | |15| +-SUBPLAN SCAN |tem |682 |88188 | | | |16| +-HASH DISTINCT | |682 |88186 | | | |17| +-HASH RIGHT OUTER JOIN | |682 |87228 | | | |18| |-TABLE FULL SCAN |m |103 |9 | | | |19| +-HASH RIGHT OUTER JOIN | |682 |86988 | | | |20| |-PX COORDINATOR | |5 |10 | | | |21| | +-EXCHANGE OUT DISTR |:EX30000 |5 |9 | | | |22| | +-TABLE FULL SCAN |l |5 |4 | | | |23| +-HASH RIGHT OUTER JOIN | |682 |86899 | | | |24| |-PX COORDINATOR | |479 |741 | | | |25| | +-EXCHANGE OUT DISTR |:EX40000 |479 |522 | | | |26| | +-TABLE FULL SCAN |t2 |479 |32 | | | |27| +-HASH RIGHT OUTER JOIN | |682 |85957 | | | |28| |-PX COORDINATOR | |479 |1272 | | | |29| | +-EXCHANGE OUT DISTR |:EX50000 |479 |895 | | | |30| | +-TABLE FULL SCAN |t1 |479 |47 | | | |31| +-NESTED-LOOP JOIN | |682 |84451 | | | |32| |-HASH JOIN | |682 |18421 | | | |33| | |-PX COORDINATOR | |26 |164 | | | |34| | | +-EXCHANGE OUT DISTR |:EX60000 |26 |142 | | | |35| | | +-HASH JOIN | |26 |93 | | | |36| | | |-SUBPLAN SCAN |b |26 |33 | | | |37| | | | +-HASH GROUP BY | |26 |33 | | | |38| | | | +-TABLE FULL SCAN |t_identify_task |117 |15 | | | |39| | | +-TABLE FULL SCAN |a |117 |16 | | | |40| | +-TABLE FULL SCAN |tem |32644 |3508 | | | |41| +-SUBPLAN SCAN |B |1 |97 | | | |42| +-NESTED-LOOP JOIN | |1 |97 | | | |43| |-NESTED-LOOP JOIN | |1 |78 | | | |44| | |-NESTED-LOOP JOIN | |1 |60 | | | |45| | | |-NESTED-LOOP JOIN | |1 |39 | | | |46| | | | |-DISTRIBUTED TABLE GET |C |1 |21 | | | |47| | | | +-DISTRIBUTED TABLE GET |F |1 |18 | | | |48| | | +-DISTRIBUTED TABLE RANGE SCAN|sr(idx_source_id) |2 |21 | | | |49| | +-DISTRIBUTED TABLE GET |D |1 |18 | | | |50| +-DISTRIBUTED TABLE GET |dai |1 |18 | | | ================================================================================================================= | | Outputs & filters: | | ------------------------------------- | | 0 - output([s2.areacode(0x7ff2a8199690)], [a.relationId(0x7ff2a817a8c0)], [UNIX_TIMESTAMP()(0x7ff2a819a0a0)], [a.hasModel(0x7ff2a817aba0)], ['1'], [s1.areaAssetId(0x7ff2a819b5d0)], | | [s1.dataName(0x7ff2a819bc30)], [s1.dataLevelId(0x7ff2a819c2b0)], [s2.dataCarrierId(0x7ff2a819c950)], [a.dataSourceId(0x7ff2a817ae80)], [a.dataSourceSystem(0x7ff2a817b160)], | | [s1.personalInfo(0x7ff2a819dcf0)], [s1.personalInfoType(0x7ff2a819e390)], [s1.infoSystemName(0x7ff2a81506f0)], [s1.dataCountGb(0x7ff2a819edd0)], [s1.dataCountStrip(0x7ff2a819f470)], | | [s2.logicStorageTypeId(0x7ff2a819fb30)], [s1.dbName(0x7ff2a81b5ce0)], [s1.dbTable(0x7ff2a81b6340)], [s1.description(0x7ff2a81b69c0)], [a.saveDeadline(0x7ff2a817c2a0)], | | [s2.processorName(0x7ff2a81b76e0)], [s2.provinceId(0x7ff2a81b8050)], [s2.fullName(0x7ff2a81b86b0)], [s1.phone_number(0x7ff2a81b8d30)], [a.dataProcessMethodIds(0x7ff2a817bce0)], | | [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.automation(0x7ff2a817c580)], ['无'], ['无'], ['999'], ['否'], ['无'], ['0'], ['无'], | | ['999'], ['0'], ['0'], ['0'], [s2.infoSystemDomains(0x7ff2a81bc660)], [s2.safeLevelProtect(0x7ff2a81bcd00)], [s2.safeRatingRecord(0x7ff2a81bd3a0)], [s2.infoSystemTypeId(0x7ff2a81bda40)], | | [s2.infoSystemIps(0x7ff2a81be0e0)], [s2.keyFacilities(0x7ff2a81be780)], [s2.safeRiskEvaluation(0x7ff2a81bee40)], [s2.evaluationTime(0x7ff2a81bf4e0)], [s2.evaluationResult(0x7ff2a81bfb80)]), filter(nil), rowset=256 | | equal_conds([s1.infoSystemName(0x7ff2a81506f0) = s2.appName(0x7ff2a81509e0)(0x7ff2a814ffa0)]), other_conds(nil) | | 1 - output([s2.areacode(0x7ff2a8199690)], [a.relationId(0x7ff2a817a8c0)], [a.hasModel(0x7ff2a817aba0)], [s2.dataCarrierId(0x7ff2a819c950)], [a.dataSourceId(0x7ff2a817ae80)], | | [a.dataSourceSystem(0x7ff2a817b160)], [s2.logicStorageTypeId(0x7ff2a819fb30)], [a.saveDeadline(0x7ff2a817c2a0)], [s2.processorName(0x7ff2a81b76e0)], [s2.provinceId(0x7ff2a81b8050)], | | [s2.fullName(0x7ff2a81b86b0)], [a.dataProcessMethodIds(0x7ff2a817bce0)], [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.automation(0x7ff2a817c580)], [s2.infoSystemDomains(0x7ff2a81bc660)], | | [s2.safeLevelProtect(0x7ff2a81bcd00)], [s2.safeRatingRecord(0x7ff2a81bd3a0)], [s2.infoSystemTypeId(0x7ff2a81bda40)], [s2.infoSystemIps(0x7ff2a81be0e0)], | | [s2.keyFacilities(0x7ff2a81be780)], [s2.safeRiskEvaluation(0x7ff2a81bee40)], [s2.evaluationTime(0x7ff2a81bf4e0)], [s2.evaluationResult(0x7ff2a81bfb80)], | | [s2.appName(0x7ff2a81509e0)]), filter(nil), rowset=256 | | equal_conds([a.appName(0x7ff2a81787a0) = s2.appName(0x7ff2a81509e0)(0x7ff2795994e0)]), other_conds(nil) | | 2 - output([a.relationId(0x7ff2a817a8c0)], [a.hasModel(0x7ff2a817aba0)], [a.dataSourceId(0x7ff2a817ae80)], [a.dataSourceSystem(0x7ff2a817b160)], [a.saveDeadline(0x7ff2a817c2a0)], | | [a.dataProcessMethodIds(0x7ff2a817bce0)], [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.automation(0x7ff2a817c580)], [a.appName(0x7ff2a81787a0)]), filter(nil), rowset=256 | | 3 - output([a.relationId(0x7ff2a817a8c0)], [a.hasModel(0x7ff2a817aba0)], [a.dataSourceId(0x7ff2a817ae80)], [a.dataSourceSystem(0x7ff2a817b160)], [a.saveDeadline(0x7ff2a817c2a0)], | | [a.dataProcessMethodIds(0x7ff2a817bce0)], [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.automation(0x7ff2a817c580)], [a.appName(0x7ff2a81787a0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 4 - output([a.relationId(0x7ff2a817a8c0)], [a.hasModel(0x7ff2a817aba0)], [a.dataSourceId(0x7ff2a817ae80)], [a.dataSourceSystem(0x7ff2a817b160)], [a.saveDeadline(0x7ff2a817c2a0)], | | [a.dataProcessMethodIds(0x7ff2a817bce0)], [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.automation(0x7ff2a817c580)], [a.appName(0x7ff2a81787a0)]), filter(nil), rowset=256 | | equal_conds([a.appName(0x7ff2a81787a0) = b.appName(0x7ff2a8178a90)(0x7ff2a8178050)], [a.updatedTime(0x7ff2a8179d70) = b.lastTime(0x7ff2a817a060)(0x7ff2a8179620)]), | | other_conds(nil) | | 5 - output([b.appName(0x7ff2a8178a90)], [b.lastTime(0x7ff2a817a060)]), filter(nil), rowset=256 | | access([b.appName(0x7ff2a8178a90)], [b.lastTime(0x7ff2a817a060)]) | | 6 - output([dsp_assets_data_approve_log.appName(0x7ff2a8152460)], [T_FUN_MAX(dsp_assets_data_approve_log.updatedTime(0x7ff2a8152ed0))(0x7ff2a81527f0)]), filter(nil), rowset=256 | | group([dsp_assets_data_approve_log.appName(0x7ff2a8152460)]), agg_func([T_FUN_MAX(dsp_assets_data_approve_log.updatedTime(0x7ff2a8152ed0))(0x7ff2a81527f0)]) | | 7 - output([dsp_assets_data_approve_log.appName(0x7ff2a8152460)], [dsp_assets_data_approve_log.updatedTime(0x7ff2a8152ed0)]), filter(nil), rowset=256 | | access([dsp_assets_data_approve_log.appName(0x7ff2a8152460)], [dsp_assets_data_approve_log.updatedTime(0x7ff2a8152ed0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([dsp_assets_data_approve_log.id(0x7ff2a81c7370)]), range(MIN ; MAX)always true | | 8 - output([a.appName(0x7ff2a81787a0)], [a.updatedTime(0x7ff2a8179d70)], [a.relationId(0x7ff2a817a8c0)], [a.hasModel(0x7ff2a817aba0)], [a.dataSourceId(0x7ff2a817ae80)], | | [a.dataSourceSystem(0x7ff2a817b160)], [a.dataProcessMethodIds(0x7ff2a817bce0)], [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.saveDeadline(0x7ff2a817c2a0)], | | [a.automation(0x7ff2a817c580)]), filter(nil), rowset=256 | | access([a.appName(0x7ff2a81787a0)], [a.updatedTime(0x7ff2a8179d70)], [a.relationId(0x7ff2a817a8c0)], [a.hasModel(0x7ff2a817aba0)], [a.dataSourceId(0x7ff2a817ae80)], | | [a.dataSourceSystem(0x7ff2a817b160)], [a.dataProcessMethodIds(0x7ff2a817bce0)], [a.dataProcessPurposeId(0x7ff2a817bfc0)], [a.saveDeadline(0x7ff2a817c2a0)], | | [a.automation(0x7ff2a817c580)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([a.id(0x7ff2a817a5e0)]), range(MIN ; MAX)always true | | 9 - output([s2.areacode(0x7ff2a8199690)], [s2.dataCarrierId(0x7ff2a819c950)], [s2.logicStorageTypeId(0x7ff2a819fb30)], [s2.processorName(0x7ff2a81b76e0)], | | [s2.provinceId(0x7ff2a81b8050)], [s2.fullName(0x7ff2a81b86b0)], [s2.infoSystemDomains(0x7ff2a81bc660)], [s2.safeLevelProtect(0x7ff2a81bcd00)], [s2.safeRatingRecord(0x7ff2a81bd3a0)], | | [s2.infoSystemTypeId(0x7ff2a81bda40)], [s2.infoSystemIps(0x7ff2a81be0e0)], [s2.keyFacilities(0x7ff2a81be780)], [s2.safeRiskEvaluation(0x7ff2a81bee40)], | | [s2.evaluationTime(0x7ff2a81bf4e0)], [s2.evaluationResult(0x7ff2a81bfb80)], [s2.appName(0x7ff2a81509e0)]), filter(nil), rowset=256 | | 10 - output([s2.areacode(0x7ff2a8199690)], [s2.dataCarrierId(0x7ff2a819c950)], [s2.logicStorageTypeId(0x7ff2a819fb30)], [s2.processorName(0x7ff2a81b76e0)], | | [s2.provinceId(0x7ff2a81b8050)], [s2.fullName(0x7ff2a81b86b0)], [s2.infoSystemDomains(0x7ff2a81bc660)], [s2.safeLevelProtect(0x7ff2a81bcd00)], [s2.safeRatingRecord(0x7ff2a81bd3a0)], | | [s2.infoSystemTypeId(0x7ff2a81bda40)], [s2.infoSystemIps(0x7ff2a81be0e0)], [s2.keyFacilities(0x7ff2a81be780)], [s2.safeRiskEvaluation(0x7ff2a81bee40)], | | [s2.evaluationTime(0x7ff2a81bf4e0)], [s2.evaluationResult(0x7ff2a81bfb80)], [s2.appName(0x7ff2a81509e0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 11 - output([s2.appName(0x7ff2a81509e0)], [s2.areacode(0x7ff2a8199690)], [s2.dataCarrierId(0x7ff2a819c950)], [s2.logicStorageTypeId(0x7ff2a819fb30)], [s2.processorName(0x7ff2a81b76e0)], | | [s2.provinceId(0x7ff2a81b8050)], [s2.fullName(0x7ff2a81b86b0)], [s2.infoSystemDomains(0x7ff2a81bc660)], [s2.safeLevelProtect(0x7ff2a81bcd00)], [s2.safeRatingRecord(0x7ff2a81bd3a0)], | | [s2.infoSystemTypeId(0x7ff2a81bda40)], [s2.infoSystemIps(0x7ff2a81be0e0)], [s2.keyFacilities(0x7ff2a81be780)], [s2.safeRiskEvaluation(0x7ff2a81bee40)], | | [s2.evaluationTime(0x7ff2a81bf4e0)], [s2.evaluationResult(0x7ff2a81bfb80)]), filter(nil), rowset=256 | | access([s2.appName(0x7ff2a81509e0)], [s2.areacode(0x7ff2a8199690)], [s2.dataCarrierId(0x7ff2a819c950)], [s2.logicStorageTypeId(0x7ff2a819fb30)], [s2.processorName(0x7ff2a81b76e0)], | | [s2.provinceId(0x7ff2a81b8050)], [s2.fullName(0x7ff2a81b86b0)], [s2.infoSystemDomains(0x7ff2a81bc660)], [s2.safeLevelProtect(0x7ff2a81bcd00)], [s2.safeRatingRecord(0x7ff2a81bd3a0)], | | [s2.infoSystemTypeId(0x7ff2a81bda40)], [s2.infoSystemIps(0x7ff2a81be0e0)], [s2.keyFacilities(0x7ff2a81be780)], [s2.safeRiskEvaluation(0x7ff2a81bee40)], | | [s2.evaluationTime(0x7ff2a81bf4e0)], [s2.evaluationResult(0x7ff2a81bfb80)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([s2.id(0x7ff2a81c7a50)]), range(MIN ; MAX)always true | | 12 - output([s1.areaAssetId(0x7ff2a819b5d0)], [s1.dataName(0x7ff2a819bc30)], [s1.dataLevelId(0x7ff2a819c2b0)], [s1.personalInfo(0x7ff2a819dcf0)], [s1.infoSystemName(0x7ff2a81506f0)], | | [s1.personalInfoType(0x7ff2a819e390)], [s1.dataCountGb(0x7ff2a819edd0)], [s1.dataCountStrip(0x7ff2a819f470)], [s1.dbName(0x7ff2a81b5ce0)], [s1.dbTable(0x7ff2a81b6340)], | | [s1.description(0x7ff2a81b69c0)], [s1.phone_number(0x7ff2a81b8d30)]), filter(nil), rowset=256 | | access([s1.areaAssetId(0x7ff2a819b5d0)], [s1.dataName(0x7ff2a819bc30)], [s1.dataLevelId(0x7ff2a819c2b0)], [s1.personalInfo(0x7ff2a819dcf0)], [s1.infoSystemName(0x7ff2a81506f0)], | | [s1.personalInfoType(0x7ff2a819e390)], [s1.dataCountGb(0x7ff2a819edd0)], [s1.dataCountStrip(0x7ff2a819f470)], [s1.dbName(0x7ff2a81b5ce0)], [s1.dbTable(0x7ff2a81b6340)], | | [s1.description(0x7ff2a81b69c0)], [s1.phone_number(0x7ff2a81b8d30)]) | | 13 - output([tem.areaAssetId(0x7ff2a8147570)], [T_FUN_GROUP_CONCAT(tem.dataName(0x7ff2a8148000))(0x7ff2a8147920)], [T_FUN_GROUP_CONCAT(tem.dataLevelId(0x7ff2a8148b10))(0x7ff2a8148430)], | | ['是'], [tem.infoSystemName(0x7ff2a81494c0)], [T_FUN_GROUP_CONCAT(tem.personalInfoType(0x7ff2a8149f90))(0x7ff2a81498b0)], [tem.data_countgb(0x7ff2a814a670)], | | [tem.data_count(0x7ff2a814acd0)], [tem.dbName(0x7ff2a814b310)], [tem.dbTable(0x7ff2a814b950)], [tem.description(0x7ff2a814bfb0)], [tem.phone_number(0x7ff2a814ccb0)]), filter(nil), rowset=256 | | group([tem.areaAssetId(0x7ff2a8147570)], [tem.dbName(0x7ff2a814b310)], [tem.infoSystemName(0x7ff2a81494c0)], [tem.phone_number(0x7ff2a814ccb0)], [tem.charge_person(0x7ff2a814c630)]), | | agg_func([T_FUN_GROUP_CONCAT(tem.dataName(0x7ff2a8148000))(0x7ff2a8147920)], [T_FUN_GROUP_CONCAT(tem.dataLevelId(0x7ff2a8148b10))(0x7ff2a8148430)], [T_FUN_GROUP_CONCAT(tem.personalInfoType(0x7ff2a8149 | | f90))(0x7ff2a81498b0)]) | | 14 - output([tem.areaAssetId(0x7ff2a8147570)], [tem.dbName(0x7ff2a814b310)], [tem.infoSystemName(0x7ff2a81494c0)], [tem.phone_number(0x7ff2a814ccb0)], | | [tem.charge_person(0x7ff2a814c630)], [tem.data_countgb(0x7ff2a814a670)], [tem.data_count(0x7ff2a814acd0)], [tem.dbTable(0x7ff2a814b950)], [tem.description(0x7ff2a814bfb0)], | | [tem.dataName(0x7ff2a8148000)], [tem.dataLevelId(0x7ff2a8148b10)], [tem.personalInfoType(0x7ff2a8149f90)]), filter(nil), rowset=256 | | sort_keys([HASH(tem.areaAssetId(0x7ff2a8147570), tem.dbName(0x7ff2a814b310), tem.infoSystemName(0x7ff2a81494c0), tem.phone_number(0x7ff2a814ccb0), | | tem.charge_person(0x7ff2a814c630))(0x7ff28be11670), ASC], [tem.areaAssetId(0x7ff2a8147570), ASC], [tem.dbName(0x7ff2a814b310), ASC], [tem.infoSystemName(0x7ff2a81494c0), | | ASC], [tem.phone_number(0x7ff2a814ccb0), ASC], [tem.charge_person(0x7ff2a814c630), ASC]) | | 15 - output([tem.areaAssetId(0x7ff2a8147570)], [tem.dataName(0x7ff2a8148000)], [tem.dataLevelId(0x7ff2a8148b10)], [tem.infoSystemName(0x7ff2a81494c0)], | | [tem.personalInfoType(0x7ff2a8149f90)], [tem.data_countgb(0x7ff2a814a670)], [tem.data_count(0x7ff2a814acd0)], [tem.dbName(0x7ff2a814b310)], [tem.dbTable(0x7ff2a814b950)], | | [tem.description(0x7ff2a814bfb0)], [tem.charge_person(0x7ff2a814c630)], [tem.phone_number(0x7ff2a814ccb0)]), filter(nil), rowset=256 | | access([tem.areaAssetId(0x7ff2a8147570)], [tem.dataName(0x7ff2a8148000)], [tem.dataLevelId(0x7ff2a8148b10)], [tem.infoSystemName(0x7ff2a81494c0)], | | [tem.personalInfoType(0x7ff2a8149f90)], [tem.data_countgb(0x7ff2a814a670)], [tem.data_count(0x7ff2a814acd0)], [tem.dbName(0x7ff2a814b310)], [tem.dbTable(0x7ff2a814b950)], | | [tem.description(0x7ff2a814bfb0)], [tem.charge_person(0x7ff2a814c630)], [tem.phone_number(0x7ff2a814ccb0)]) | | 16 - output([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.data_count(0x7ff2a813f750)], | | [ifnull(m.code(0x7ff2a8140950), cast('5', VARCHAR(255))(0x7ff2a8145960))(0x7ff2a813fb00)], [t2.business_name(0x7ff2a8131d20)], [l.name(0x7ff2a81435a0)], | | [B.app_name(0x7ff2a8143c00)], [B.charge_person(0x7ff2a8144350)], [B.data_countgb(0x7ff2a81449d0)], [B.phone_number(0x7ff2a8145050)]), filter(nil), rowset=256 | | distinct([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [ifnull(m.code(0x7ff2a8140950), cast('5', VARCHAR(255))(0x7ff2a8145960))(0x7ff2a813fb00)], | | [t2.business_name(0x7ff2a8131d20)], [l.name(0x7ff2a81435a0)], [B.app_name(0x7ff2a8143c00)], [B.charge_person(0x7ff2a8144350)], [B.phone_number(0x7ff2a8145050)]) | | 17 - output([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [t2.business_name(0x7ff2a8131d20)], [l.name(0x7ff2a81435a0)], [B.app_name(0x7ff2a8143c00)], | | [B.charge_person(0x7ff2a8144350)], [B.phone_number(0x7ff2a8145050)], [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.data_count(0x7ff2a813f750)], | | [B.data_countgb(0x7ff2a81449d0)], [m.code(0x7ff2a8140950)]), filter(nil), rowset=256 | | equal_conds([t1.business_name(0x7ff2a8115f50) = m.relationName(0x7ff2a813d720)(0x7ff2a813cce0)]), other_conds(nil) | | 18 - output([m.relationName(0x7ff2a813d720)], [m.code(0x7ff2a8140950)]), filter(nil), rowset=256 | | access([m.relationName(0x7ff2a813d720)], [m.code(0x7ff2a8140950)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([m.id(0x7ff2a81c3e50)]), range(MIN ; MAX)always true | | 19 - output([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [t2.business_name(0x7ff2a8131d20)], [l.name(0x7ff2a81435a0)], [B.app_name(0x7ff2a8143c00)], | | [B.charge_person(0x7ff2a8144350)], [B.phone_number(0x7ff2a8145050)], [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.data_count(0x7ff2a813f750)], | | [B.data_countgb(0x7ff2a81449d0)], [t1.business_name(0x7ff2a8115f50)]), filter(nil), rowset=256 | | equal_conds([t1.level_id(0x7ff2a8117930) = l.id(0x7ff2a8139f30)(0x7ff2a81394f0)]), other_conds(nil) | | 20 - output([l.name(0x7ff2a81435a0)], [l.id(0x7ff2a8139f30)]), filter(nil), rowset=256 | | 21 - output([l.name(0x7ff2a81435a0)], [l.id(0x7ff2a8139f30)]), filter(nil), rowset=256 | | is_single, dop=1 | | 22 - output([l.id(0x7ff2a8139f30)], [l.name(0x7ff2a81435a0)]), filter(nil), rowset=256 | | access([l.id(0x7ff2a8139f30)], [l.name(0x7ff2a81435a0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([l.id(0x7ff2a8139f30)]), range(MIN ; MAX)always true | | 23 - output([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [t2.business_name(0x7ff2a8131d20)], [B.app_name(0x7ff2a8143c00)], [B.charge_person(0x7ff2a8144350)], | | [B.phone_number(0x7ff2a8145050)], [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.data_count(0x7ff2a813f750)], [B.data_countgb(0x7ff2a81449d0)], | | [t1.business_name(0x7ff2a8115f50)], [t1.level_id(0x7ff2a8117930)]), filter(nil), rowset=256 | | equal_conds([cast(t1.parent_id(0x7ff2a8101a60), DECIMAL(-1, -1))(0x7ff2a81145c0) = cast(t2.id(0x7ff2a8114050), DECIMAL(11, 0))(0x7ff2a8115110)(0x7ff2a8101310)]), | | other_conds(nil) | | 24 - output([t2.business_name(0x7ff2a8131d20)], [t2.id(0x7ff2a8114050)]), filter(nil), rowset=256 | | 25 - output([t2.business_name(0x7ff2a8131d20)], [t2.id(0x7ff2a8114050)]), filter(nil), rowset=256 | | is_single, dop=1 | | 26 - output([t2.id(0x7ff2a8114050)], [t2.business_name(0x7ff2a8131d20)]), filter(nil), rowset=256 | | access([t2.id(0x7ff2a8114050)], [t2.business_name(0x7ff2a8131d20)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([t2.id(0x7ff2a8114050)]), range(MIN ; MAX)always true | | 27 - output([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [B.app_name(0x7ff2a8143c00)], [B.charge_person(0x7ff2a8144350)], [B.phone_number(0x7ff2a8145050)], | | [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.data_count(0x7ff2a813f750)], [B.data_countgb(0x7ff2a81449d0)], [t1.parent_id(0x7ff2a8101a60)], | | [t1.business_name(0x7ff2a8115f50)], [t1.level_id(0x7ff2a8117930)]), filter(nil), rowset=256 | | equal_conds([cast(tem.identify_business_id(0x7ff2a80a87c0), DECIMAL(-1, -1))(0x7ff2a8137530) = cast(t1.id(0x7ff2a8115c70), DECIMAL(11, 0))(0x7ff2a8138080)(0x7ff2a8136580)]), | | other_conds(nil) | | 28 - output([t1.id(0x7ff2a8115c70)], [t1.parent_id(0x7ff2a8101a60)], [t1.business_name(0x7ff2a8115f50)], [t1.level_id(0x7ff2a8117930)]), filter(nil), rowset=256 | | 29 - output([t1.id(0x7ff2a8115c70)], [t1.parent_id(0x7ff2a8101a60)], [t1.business_name(0x7ff2a8115f50)], [t1.level_id(0x7ff2a8117930)]), filter(nil), rowset=256 | | is_single, dop=1 | | 30 - output([t1.id(0x7ff2a8115c70)], [t1.parent_id(0x7ff2a8101a60)], [t1.business_name(0x7ff2a8115f50)], [t1.level_id(0x7ff2a8117930)]), filter(nil), rowset=256 | | access([t1.id(0x7ff2a8115c70)], [t1.parent_id(0x7ff2a8101a60)], [t1.business_name(0x7ff2a8115f50)], [t1.level_id(0x7ff2a8117930)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([t1.id(0x7ff2a8115c70)]), range(MIN ; MAX)always true | | 31 - output([B.table_id(0x7ff2a80fc140)], [B.default_schema(0x7ff2a813e3d0)], [B.app_name(0x7ff2a8143c00)], [B.charge_person(0x7ff2a8144350)], [B.phone_number(0x7ff2a8145050)], | | [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.data_count(0x7ff2a813f750)], [B.data_countgb(0x7ff2a81449d0)], [tem.identify_business_id(0x7ff2a80a87c0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([tem.source_id(0x7ff2a80a76b0)(:16)], [tem.table_id(0x7ff2a80a8200)(:17)], [tem.field_id(0x7ff2a80a84e0)(:18)]), use_batch=false | | 32 - output([tem.source_id(0x7ff2a80a76b0)], [tem.table_id(0x7ff2a80a8200)], [tem.field_id(0x7ff2a80a84e0)], [tem.identify_business_id(0x7ff2a80a87c0)]), filter(nil), rowset=256 | | equal_conds([tem.task_id(0x7ff2a80a60e0) = a.id(0x7ff2a80a4850)(0x7ff2a80a5990)], [tem.source_id(0x7ff2a80a76b0) = a.source_id(0x7ff2a80a3910)(0x7ff2a80a6f60)]), | | other_conds(nil) | | 33 - output([a.source_id(0x7ff2a80a3910)], [a.id(0x7ff2a80a4850)]), filter(nil), rowset=256 | | 34 - output([a.source_id(0x7ff2a80a3910)], [a.id(0x7ff2a80a4850)]), filter(nil), rowset=256 | | is_single, dop=1 | | 35 - output([a.source_id(0x7ff2a80a3910)], [a.id(0x7ff2a80a4850)]), filter(nil), rowset=256 | | equal_conds([a.source_id(0x7ff2a80a3910) = b.source_id(0x7ff2a80a3c00)(0x7ff2a80a31c0)], [a.update_time(0x7ff2a80a2340) = b.maxtime(0x7ff2a80a2630)(0x7ff2a80a1bf0)]), | | other_conds(nil) | | 36 - output([b.maxtime(0x7ff2a80a2630)], [b.source_id(0x7ff2a80a3c00)]), filter(nil), rowset=256 | | access([b.maxtime(0x7ff2a80a2630)], [b.source_id(0x7ff2a80a3c00)]) | | 37 - output([T_FUN_MAX(t_identify_task.update_time(0x7ff2a80a05f0))(0x7ff2a809ff10)], [t_identify_task.source_id(0x7ff2a80a0cb0)]), filter(nil), rowset=256 | | group([t_identify_task.source_id(0x7ff2a80a0cb0)]), agg_func([T_FUN_MAX(t_identify_task.update_time(0x7ff2a80a05f0))(0x7ff2a809ff10)]) | | 38 - output([t_identify_task.update_time(0x7ff2a80a05f0)], [t_identify_task.source_id(0x7ff2a80a0cb0)]), filter([t_identify_task.source_id(0x7ff2a80a0cb0) | | != cast('', VARCHAR(1048576))(0x7ff2a80df120)(0x7ff27950b690)]), rowset=256 | | access([t_identify_task.update_time(0x7ff2a80a05f0)], [t_identify_task.source_id(0x7ff2a80a0cb0)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([t_identify_task.id(0x7ff2a81c2080)]), range(MIN ; MAX)always true | | 39 - output([a.id(0x7ff2a80a4850)], [a.update_time(0x7ff2a80a2340)], [a.source_id(0x7ff2a80a3910)]), filter([a.source_id(0x7ff2a80a3910) != cast('', VARCHAR(1048576))(0x7ff2a80df120)(0x7ff27950a370)]), rowset=256 | | access([a.id(0x7ff2a80a4850)], [a.update_time(0x7ff2a80a2340)], [a.source_id(0x7ff2a80a3910)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([a.id(0x7ff2a80a4850)]), range(MIN ; MAX)always true | | 40 - output([tem.task_id(0x7ff2a80a60e0)], [tem.source_id(0x7ff2a80a76b0)], [tem.table_id(0x7ff2a80a8200)], [tem.field_id(0x7ff2a80a84e0)], [tem.identify_business_id(0x7ff2a80a87c0)]), filter([tem.sou | | rce_id(0x7ff2a80a76b0) != cast('', VARCHAR(1048576))(0x7ff2a80df120)(0x7ff2795099e0)]), rowset=256 | | access([tem.task_id(0x7ff2a80a60e0)], [tem.source_id(0x7ff2a80a76b0)], [tem.table_id(0x7ff2a80a8200)], [tem.field_id(0x7ff2a80a84e0)], [tem.identify_business_id(0x7ff2a80a87c0)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([tem.id(0x7ff2a80d1f60)]), range(MIN ; MAX)always true | | 41 - output([B.table_id(0x7ff2a80fc140)], [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.default_schema(0x7ff2a813e3d0)], [B.charge_person(0x7ff2a8144350)], | | [B.data_count(0x7ff2a813f750)], [B.data_countgb(0x7ff2a81449d0)], [B.phone_number(0x7ff2a8145050)], [B.app_name(0x7ff2a8143c00)]), filter(nil), rowset=256 | | access([B.table_id(0x7ff2a80fc140)], [B.table_name(0x7ff2a813ea50)], [B.table_desc(0x7ff2a813f0d0)], [B.default_schema(0x7ff2a813e3d0)], [B.charge_person(0x7ff2a8144350)], | | [B.data_count(0x7ff2a813f750)], [B.data_countgb(0x7ff2a81449d0)], [B.phone_number(0x7ff2a8145050)], [B.app_name(0x7ff2a8143c00)]) | | 42 - output([F.source_id(0x7ff2a80da440)], [F.id(0x7ff2a80ddc30)], [F.name(0x7ff2a80f2760)], [F.notes(0x7ff2a80f2da0)], [C.id(0x7ff2a80f33e0)], [D.default_schema(0x7ff2a80f4d80)], | | [dai.charge_person(0x7ff2a80f5420)], [F.data_count(0x7ff2a80f5aa0)], [F.data_countgb(0x7ff2a80f6120)], [dai.phone_number(0x7ff2a80f86d0)], [dai.app_name(0x7ff2a80f93b0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([sr.app_id(0x7ff2a80d5360)(:20)]), use_batch=true | | 43 - output([sr.app_id(0x7ff2a80d5360)], [F.source_id(0x7ff2a80da440)], [F.id(0x7ff2a80ddc30)], [F.name(0x7ff2a80f2760)], [F.notes(0x7ff2a80f2da0)], [C.id(0x7ff2a80f33e0)], | | [D.default_schema(0x7ff2a80f4d80)], [F.data_count(0x7ff2a80f5aa0)], [F.data_countgb(0x7ff2a80f6120)]), filter(nil), rowset=256 | | conds(nil), nl_params_([sr.source_id(0x7ff2a80d8b50)(:21)]), use_batch=true | | 44 - output([sr.app_id(0x7ff2a80d5360)], [F.source_id(0x7ff2a80da440)], [F.id(0x7ff2a80ddc30)], [F.name(0x7ff2a80f2760)], [F.notes(0x7ff2a80f2da0)], [C.id(0x7ff2a80f33e0)], | | [F.data_count(0x7ff2a80f5aa0)], [F.data_countgb(0x7ff2a80f6120)], [sr.source_id(0x7ff2a80d8b50)]), filter(nil), rowset=256 | | conds(nil), nl_params_([F.source_id(0x7ff2a80da440)(:24)]), use_batch=true | | 45 - output([F.source_id(0x7ff2a80da440)], [F.id(0x7ff2a80ddc30)], [F.name(0x7ff2a80f2760)], [F.notes(0x7ff2a80f2da0)], [C.id(0x7ff2a80f33e0)], [F.data_count(0x7ff2a80f5aa0)], | | [F.data_countgb(0x7ff2a80f6120)]), filter(nil), rowset=256 | | conds(nil), nl_params_([C.table_id(0x7ff2a80dd940)(:28)]), use_batch=true | | 46 - output([C.id(0x7ff2a80f33e0)], [C.table_id(0x7ff2a80dd940)]), filter(nil), rowset=256 | | access([C.id(0x7ff2a80f33e0)], [C.table_id(0x7ff2a80dd940)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([C.id(0x7ff2a80f33e0)]), range(MIN ; MAX)always true, | | range_cond([C.id(0x7ff2a80f33e0) = :18(0x7ff2719f1de0)]) | | 47 - output([F.id(0x7ff2a80ddc30)], [F.source_id(0x7ff2a80da440)], [F.name(0x7ff2a80f2760)], [F.notes(0x7ff2a80f2da0)], [F.data_count(0x7ff2a80f5aa0)], | | [F.data_countgb(0x7ff2a80f6120)]), filter([:16 = F.source_id(0x7ff2a80da440)(0x7ff2719f0cc0)], [F.source_id(0x7ff2a80da440) != cast('', VARCHAR(1048576))(0x7ff2a80df120)(0x7ff27950c9b0)]), rowset=256 | | access([GROUP_ID(0x7ff274c0bc90)], [F.id(0x7ff2a80ddc30)], [F.source_id(0x7ff2a80da440)], [F.name(0x7ff2a80f2760)], [F.notes(0x7ff2a80f2da0)], [F.data_count(0x7ff2a80f5aa0)], | | [F.data_countgb(0x7ff2a80f6120)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false,false], | | range_key([F.id(0x7ff2a80ddc30)]), range(MIN ; MAX), | | range_cond([F.id(0x7ff2a80ddc30) = :17(0x7ff2719f1550)], [:28 = F.id(0x7ff2a80ddc30)(0x7ff28873da40)]) | | 48 - output([sr.app_id(0x7ff2a80d5360)], [sr.source_id(0x7ff2a80d8b50)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff274c0fd00)], [sr.id(0x7ff2a81c2de0)], [sr.app_id(0x7ff2a80d5360)], [sr.source_id(0x7ff2a80d8b50)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([sr.source_id(0x7ff2a80d8b50)], [sr.id(0x7ff2a81c2de0)]), range(MIN ; MAX), | | range_cond([:24 = sr.source_id(0x7ff2a80d8b50)(0x7ff2886de4c0)]) | | 49 - output([D.default_schema(0x7ff2a80f4d80)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff274c11e60)], [D.default_schema(0x7ff2a80f4d80)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([D.id(0x7ff2a80d8e40)]), range(MIN ; MAX), | | range_cond([:21 = D.id(0x7ff2a80d8e40)(0x7ff2886ae0c0)]) | | 50 - output([dai.charge_person(0x7ff2a80f5420)], [dai.phone_number(0x7ff2a80f86d0)], [dai.app_name(0x7ff2a80f93b0)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7ff274c14050)], [dai.charge_person(0x7ff2a80f5420)], [dai.phone_number(0x7ff2a80f86d0)], [dai.app_name(0x7ff2a80f93b0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([dai.id(0x7ff2a80d5650)]), range(MIN ; MAX), | | range_cond([:20 = dai.id(0x7ff2a80d5650)(0x7ff28869c6b0)]) | | 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$2B7FEE85 > SEL$49D1E181 | | stmt_id:4, SEL$4 > SEL$4BA74CF5 > SEL$9302C0D4 > SEL$6DE88B08 | | stmt_id:5, SEL$5 > SEL$3FC86D63 > SEL$52F03D80 | | stmt_id:6, SEL$6 > SEL$7467AFC1 > SEL$7AE32D32 | | stmt_id:7, SEL$7 > SEL$341AAD84 > SEL$0E55D08F > SEL$102DE286 | | 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" ((("b"@"SEL$9" "db1"."a"@"SEL$9") "db1"."s2"@"SEL$1") "s1"@"SEL$1")) | | USE_HASH(@"SEL$659CB5A9" "s1"@"SEL$1") | | USE_HASH(@"SEL$659CB5A9" "db1"."s2"@"SEL$1") | | PQ_DISTRIBUTE(@"SEL$659CB5A9" "db1"."s2"@"SEL$1" LOCAL LOCAL) | | 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") | | NO_USE_HASH_AGGREGATION(@"SEL$2F8A4177" PARTITION_SORT) | | USE_HASH_DISTINCT(@"SEL$49D1E181") | | LEADING(@"SEL$49D1E181" ("db1"."m"@"SEL$3" ("db1"."l"@"SEL$3" ("db1"."t2"@"SEL$8" ("db1"."t1"@"SEL$8" ((("b"@"SEL$5" "db1"."a"@"SEL$5") "db1"."tem"@"SEL$4") "B"@"SEL$3")))))) | | USE_HASH(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "db1"."t2"@"SEL$8" "db1"."t1"@"SEL$8" "db1"."l"@"SEL$3" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3")) | | FULL(@"SEL$49D1E181" "m"@"SEL$3") | | USE_HASH(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "db1"."t2"@"SEL$8" "db1"."t1"@"SEL$8" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3")) | | PQ_DISTRIBUTE(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "db1"."t2"@"SEL$8" "db1"."t1"@"SEL$8" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3") LOCAL LOCAL) | | FULL(@"SEL$49D1E181" "l"@"SEL$3") | | USE_HASH(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "db1"."t1"@"SEL$8" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3")) | | PQ_DISTRIBUTE(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "db1"."t1"@"SEL$8" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3") LOCAL LOCAL) | | FULL(@"SEL$49D1E181" "t2"@"SEL$8") | | USE_HASH(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3")) | | PQ_DISTRIBUTE(@"SEL$49D1E181" ("db1"."tem"@"SEL$4" "b"@"SEL$5" "db1"."a"@"SEL$5" "B"@"SEL$3") LOCAL LOCAL) | | FULL(@"SEL$49D1E181" "t1"@"SEL$8") | | USE_NL(@"SEL$49D1E181" "B"@"SEL$3") | | USE_HASH(@"SEL$49D1E181" "db1"."tem"@"SEL$4") | | PQ_DISTRIBUTE(@"SEL$49D1E181" "db1"."tem"@"SEL$4" LOCAL LOCAL) | | USE_HASH(@"SEL$49D1E181" "db1"."a"@"SEL$5") | | USE_HASH_AGGREGATION(@"SEL$7AE32D32") | | FULL(@"SEL$7AE32D32" "db1"."t_identify_task"@"SEL$6") | | FULL(@"SEL$49D1E181" "a"@"SEL$5") | | FULL(@"SEL$49D1E181" "tem"@"SEL$4") | | LEADING(@"SEL$102DE286" (((("db1"."C"@"SEL$7" "db1"."F"@"SEL$7") "db1"."sr"@"SEL$7") "db1"."D"@"SEL$7") "db1"."dai"@"SEL$7")) | | USE_NL(@"SEL$102DE286" "db1"."dai"@"SEL$7") | | USE_NL(@"SEL$102DE286" "db1"."D"@"SEL$7") | | USE_NL(@"SEL$102DE286" "db1"."sr"@"SEL$7") | | USE_NL(@"SEL$102DE286" "db1"."F"@"SEL$7") | | FULL(@"SEL$102DE286" "C"@"SEL$7") | | USE_DAS(@"SEL$102DE286" "C"@"SEL$7") | | FULL(@"SEL$102DE286" "F"@"SEL$7") | | USE_DAS(@"SEL$102DE286" "F"@"SEL$7") | | INDEX(@"SEL$102DE286" "sr"@"SEL$7" "idx_source_id") | | USE_DAS(@"SEL$102DE286" "sr"@"SEL$7") | | FULL(@"SEL$102DE286" "D"@"SEL$7") | | USE_DAS(@"SEL$102DE286" "D"@"SEL$7") | | FULL(@"SEL$102DE286" "dai"@"SEL$7") | | USE_DAS(@"SEL$102DE286" "dai"@"SEL$7") | | SIMPLIFY_DISTINCT(@"SEL$6") | | SIMPLIFY_DISTINCT(@"SEL$5") | | SIMPLIFY_DISTINCT(@"SEL$4") | | PROJECT_PRUNE(@"SEL$2") | | PROJECT_PRUNE(@"SEL$9") | | PROJECT_PRUNE(@"SEL$4BA74CF5") | | PROJECT_PRUNE(@"SEL$7") | | PROJECT_PRUNE(@"SEL$8") | | PROJECT_PRUNE(@"SEL$3FC86D63") | | MERGE(@"SEL$52F03D80" > "SEL$9302C0D4") | | MERGE(@"SEL$6DE88B08" > "SEL$3") | | MERGE(@"SEL$E9D4444A" > "SEL$3") | | MERGE(@"SEL$FFA30D18" > "SEL$1") | | OUTER_TO_INNER(@"SEL$341AAD84") | | OUTER_TO_INNER(@"SEL$3D2404FF") | | PRED_DEDUCE(@"SEL$2B7FEE85") | | PRED_DEDUCE(@"SEL$7467AFC1") | | PRED_DEDUCE(@"SEL$0E55D08F") | | OPTIMIZER_FEATURES_ENABLE('4.2.1.7') | | END_OUTLINE_DATA | | */ | | Optimization Info: | | ------------------------------------- | | 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 | | m: | | table_rows:103 | | physical_range_rows:103 | | logical_range_rows:103 | | index_back_rows:0 | | output_rows:103 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_relationName, dsp_assets_data_code_info] | | stats version:1742958168713886 | | 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 | | t2: | | table_rows:479 | | physical_range_rows:479 | | logical_range_rows:479 | | index_back_rows:0 | | output_rows:479 | | 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 | | t1: | | table_rows:479 | | physical_range_rows:479 | | logical_range_rows:479 | | index_back_rows:0 | | output_rows:479 | | 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 | | 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 | | a: | | 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 | | 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 | | D: | | table_rows:126 | | 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:[t_collect_source_info] | | stats version:1742958169314866 | | 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 | | Plan Type: | | DISTRIBUTED | | Note: | | Degree of Parallelisim is 1 because of table property | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+