Plan signature: 8147181005665978177 ==================================================== |ID|OPERATOR |NAME |EST. ROWS|COST| ---------------------------------------------------- |0 |PX COORDINATOR | |1 |67 | |1 | EXCHANGE OUT DISTR |:EX10000|1 |59 | |2 | PX PARTITION ITERATOR| |1 |41 | |3 | TABLE SCAN |gjfq |1 |41 | ==================================================== Outputs & filters: ------------------------------------- 0 - output([INTERNAL_FUNCTION(gjfq.clearId(0x7fd39bc3afd0), gjfq.alarmTitle(0x7fd39bc3b2b0), gjfq.equipmentClass(0x7fd39bc3b590), gjfq.maker(0x7fd39bc3b870), gjfq.standardCode(0x7fd39bc3bb50), gjfq.standardName(0x7fd39bc3be30), gjfq.utranCell(0x7fd39bc3c110), gjfq.eventTime(0x7fd39bc3c3f0), gjfq.clearTime(0x7fd39bc3c6d0), gjfq.dzOrXq(0x7fd39bc3c9b0), gjfq.gridName(0x7fd39bc3cc90), gjfq.dzSc(0x7fd39bc3cf70), gjfq.week(0x7fd39bc3d250), gjfq.year(0x7fd39bc39fd0), gjfq.standardZs(0x7fd39bc3d530), gjfq.gsxzq(0x7fd39bc3d810), gjfq.cj(0x7fd39bc3fa80), gjfq.dzMinute(0x7fd39bc3fd60), gjfq.eventDay(0x7fd39bc40040), gjfq.eventH(0x7fd39bc40320), gjfq.eventMonth(0x7fd39bc3acf0), gjfq.codeOrName(0x7fd39bc40600), gjfq.fdz(0x7fd39bc408e0), gjfq.gjStandardZs(0x7fd39bc40bc0), gjfq.ssjxOver(0x7fd39bc40ea0), gjfq.impDay(0x7fd39bc41180), gjfq.staticIn(0x7fd39bc41460), gjfq.pushDingTalk(0x7fd39bc41740))(0x7fd39bcdc1f0)]), filter(nil), rowset=256 1 - output([INTERNAL_FUNCTION(gjfq.clearId(0x7fd39bc3afd0), gjfq.alarmTitle(0x7fd39bc3b2b0), gjfq.equipmentClass(0x7fd39bc3b590), gjfq.maker(0x7fd39bc3b870), gjfq.standardCode(0x7fd39bc3bb50), gjfq.standardName(0x7fd39bc3be30), gjfq.utranCell(0x7fd39bc3c110), gjfq.eventTime(0x7fd39bc3c3f0), gjfq.clearTime(0x7fd39bc3c6d0), gjfq.dzOrXq(0x7fd39bc3c9b0), gjfq.gridName(0x7fd39bc3cc90), gjfq.dzSc(0x7fd39bc3cf70), gjfq.week(0x7fd39bc3d250), gjfq.year(0x7fd39bc39fd0), gjfq.standardZs(0x7fd39bc3d530), gjfq.gsxzq(0x7fd39bc3d810), gjfq.cj(0x7fd39bc3fa80), gjfq.dzMinute(0x7fd39bc3fd60), gjfq.eventDay(0x7fd39bc40040), gjfq.eventH(0x7fd39bc40320), gjfq.eventMonth(0x7fd39bc3acf0), gjfq.codeOrName(0x7fd39bc40600), gjfq.fdz(0x7fd39bc408e0), gjfq.gjStandardZs(0x7fd39bc40bc0), gjfq.ssjxOver(0x7fd39bc40ea0), gjfq.impDay(0x7fd39bc41180), gjfq.staticIn(0x7fd39bc41460), gjfq.pushDingTalk(0x7fd39bc41740))(0x7fd39bcdc1f0)]), filter(nil), rowset=256, dop=1 2 - output([gjfq.year(0x7fd39bc39fd0)], [gjfq.eventMonth(0x7fd39bc3acf0)], [gjfq.clearId(0x7fd39bc3afd0)], [gjfq.alarmTitle(0x7fd39bc3b2b0)], [gjfq.equipmentClass(0x7fd39bc3b590)], [gjfq.maker(0x7fd39bc3b870)], [gjfq.standardCode(0x7fd39bc3bb50)], [gjfq.standardName(0x7fd39bc3be30)], [gjfq.utranCell(0x7fd39bc3c110)], [gjfq.eventTime(0x7fd39bc3c3f0)], [gjfq.clearTime(0x7fd39bc3c6d0)], [gjfq.dzOrXq(0x7fd39bc3c9b0)], [gjfq.gridName(0x7fd39bc3cc90)], [gjfq.dzSc(0x7fd39bc3cf70)], [gjfq.week(0x7fd39bc3d250)], [gjfq.standardZs(0x7fd39bc3d530)], [gjfq.gsxzq(0x7fd39bc3d810)], [gjfq.cj(0x7fd39bc3fa80)], [gjfq.dzMinute(0x7fd39bc3fd60)], [gjfq.eventDay(0x7fd39bc40040)], [gjfq.eventH(0x7fd39bc40320)], [gjfq.codeOrName(0x7fd39bc40600)], [gjfq.fdz(0x7fd39bc408e0)], [gjfq.gjStandardZs(0x7fd39bc40bc0)], [gjfq.ssjxOver(0x7fd39bc40ea0)], [gjfq.impDay(0x7fd39bc41180)], [gjfq.staticIn(0x7fd39bc41460)], [gjfq.pushDingTalk(0x7fd39bc41740)]), filter(nil), rowset=256, force partition granule. 3 - output([gjfq.year(0x7fd39bc39fd0)], [gjfq.eventMonth(0x7fd39bc3acf0)], [gjfq.clearId(0x7fd39bc3afd0)], [gjfq.alarmTitle(0x7fd39bc3b2b0)], [gjfq.equipmentClass(0x7fd39bc3b590)], [gjfq.maker(0x7fd39bc3b870)], [gjfq.standardCode(0x7fd39bc3bb50)], [gjfq.standardName(0x7fd39bc3be30)], [gjfq.utranCell(0x7fd39bc3c110)], [gjfq.eventTime(0x7fd39bc3c3f0)], [gjfq.clearTime(0x7fd39bc3c6d0)], [gjfq.dzOrXq(0x7fd39bc3c9b0)], [gjfq.gridName(0x7fd39bc3cc90)], [gjfq.dzSc(0x7fd39bc3cf70)], [gjfq.week(0x7fd39bc3d250)], [gjfq.standardZs(0x7fd39bc3d530)], [gjfq.gsxzq(0x7fd39bc3d810)], [gjfq.cj(0x7fd39bc3fa80)], [gjfq.dzMinute(0x7fd39bc3fd60)], [gjfq.eventDay(0x7fd39bc40040)], [gjfq.eventH(0x7fd39bc40320)], [gjfq.codeOrName(0x7fd39bc40600)], [gjfq.fdz(0x7fd39bc408e0)], [gjfq.gjStandardZs(0x7fd39bc40bc0)], [gjfq.ssjxOver(0x7fd39bc40ea0)], [gjfq.impDay(0x7fd39bc41180)], [gjfq.staticIn(0x7fd39bc41460)], [gjfq.pushDingTalk(0x7fd39bc41740)]), filter(nil), rowset=256, access([gjfq.year(0x7fd39bc39fd0)], [gjfq.eventMonth(0x7fd39bc3acf0)], [gjfq.clearId(0x7fd39bc3afd0)], [gjfq.alarmTitle(0x7fd39bc3b2b0)], [gjfq.equipmentClass(0x7fd39bc3b590)], [gjfq.maker(0x7fd39bc3b870)], [gjfq.standardCode(0x7fd39bc3bb50)], [gjfq.standardName(0x7fd39bc3be30)], [gjfq.utranCell(0x7fd39bc3c110)], [gjfq.eventTime(0x7fd39bc3c3f0)], [gjfq.clearTime(0x7fd39bc3c6d0)], [gjfq.dzOrXq(0x7fd39bc3c9b0)], [gjfq.gridName(0x7fd39bc3cc90)], [gjfq.dzSc(0x7fd39bc3cf70)], [gjfq.week(0x7fd39bc3d250)], [gjfq.standardZs(0x7fd39bc3d530)], [gjfq.gsxzq(0x7fd39bc3d810)], [gjfq.cj(0x7fd39bc3fa80)], [gjfq.dzMinute(0x7fd39bc3fd60)], [gjfq.eventDay(0x7fd39bc40040)], [gjfq.eventH(0x7fd39bc40320)], [gjfq.codeOrName(0x7fd39bc40600)], [gjfq.fdz(0x7fd39bc408e0)], [gjfq.gjStandardZs(0x7fd39bc40bc0)], [gjfq.ssjxOver(0x7fd39bc40ea0)], [gjfq.impDay(0x7fd39bc41180)], [gjfq.staticIn(0x7fd39bc41460)], [gjfq.pushDingTalk(0x7fd39bc41740)]), partitions(p0sp[0-11], p1sp[0-11]), is_index_back=false, range_key([gjfq.__pk_increment(0x7fd39bc4f7e0)]), range(MIN ; MAX)always true Used Hint: ------------------------------------- /*+ */ Qb name trace: ------------------------------------- stmt_id:0, stmt_type:T_EXPLAIN stmt_id:1, SEL$1 Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA FULL(@"SEL$1" "wcnkafa"."gjfq"@"SEL$1") OPTIMIZER_FEATURES_ENABLE('4.0.0.0') END_OUTLINE_DATA */ Plan Type: ------------------------------------- DISTRIBUTED Optimization Info: ------------------------------------- gjfq:table_rows:1, physical_range_rows:1, logical_range_rows:1, index_back_rows:0, output_rows:1, est_method:default_stat, optimization_method=cost_based, avaiable_index_name[gjfq], pruned_index_name[IDX_eventTime,IDX_clearTime,IDX_dzOrXq,IDX_standardZs,IDX_eventDay,IDX_eventMonth,IDX_clearId,IDX_dzMinute,IDX_codeOrName,IDX_gridName,IDX_utranCell,IDX_dzOrXq_eventMonth] Parameters: -------------------------------------