Plan signature: 8926641095398393553 ================================================== |ID|OPERATOR |NAME|EST. ROWS|COST | -------------------------------------------------- |0 |EXCHANGE IN REMOTE | |6836241 |179726027| |1 | EXCHANGE OUT REMOTE| |6836241 |125483873| |2 | TABLE SCAN |gj |6836241 |3375110 | ================================================== Outputs & filters: ------------------------------------- 0 - output([gj.clearId(0x7fd582a395c0)], [gj.alarmTitle(0x7fd582a398a0)], [gj.equipmentClass(0x7fd582a39b80)], [gj.maker(0x7fd582a39e60)], [gj.standardCode(0x7fd582a3a140)], [gj.standardName(0x7fd582a3a420)], [gj.utranCell(0x7fd582a3a700)], [gj.eventTime(0x7fd582a3a9e0)], [gj.clearTime(0x7fd582a3acc0)], [gj.dzOrXq(0x7fd582a3afa0)], [gj.gridName(0x7fd582a3b280)], [gj.dzSc(0x7fd582a3b560)], [gj.week(0x7fd582a3b840)], [gj.year(0x7fd582a3bb20)], [gj.standardZs(0x7fd582a3be00)], [gj.gsxzq(0x7fd582a3c0e0)], [gj.cj(0x7fd582a3c3c0)], [gj.dzMinute(0x7fd582a3e630)], [gj.eventDay(0x7fd582a3e910)], [gj.eventH(0x7fd582a3ebf0)], [gj.eventMonth(0x7fd582a3eed0)], [gj.codeOrName(0x7fd582a3f1b0)], [gj.fdz(0x7fd582a3f490)], [gj.gjStandardZs(0x7fd582a3f770)], [gj.ssjxOver(0x7fd582a3fa50)], [gj.impDay(0x7fd582a3fd30)], [gj.staticIn(0x7fd582a40010)], [gj.pushDingTalk(0x7fd582a402f0)]), filter(nil) 1 - output([gj.clearId(0x7fd582a395c0)], [gj.alarmTitle(0x7fd582a398a0)], [gj.equipmentClass(0x7fd582a39b80)], [gj.maker(0x7fd582a39e60)], [gj.standardCode(0x7fd582a3a140)], [gj.standardName(0x7fd582a3a420)], [gj.utranCell(0x7fd582a3a700)], [gj.eventTime(0x7fd582a3a9e0)], [gj.clearTime(0x7fd582a3acc0)], [gj.dzOrXq(0x7fd582a3afa0)], [gj.gridName(0x7fd582a3b280)], [gj.dzSc(0x7fd582a3b560)], [gj.week(0x7fd582a3b840)], [gj.year(0x7fd582a3bb20)], [gj.standardZs(0x7fd582a3be00)], [gj.gsxzq(0x7fd582a3c0e0)], [gj.cj(0x7fd582a3c3c0)], [gj.dzMinute(0x7fd582a3e630)], [gj.eventDay(0x7fd582a3e910)], [gj.eventH(0x7fd582a3ebf0)], [gj.eventMonth(0x7fd582a3eed0)], [gj.codeOrName(0x7fd582a3f1b0)], [gj.fdz(0x7fd582a3f490)], [gj.gjStandardZs(0x7fd582a3f770)], [gj.ssjxOver(0x7fd582a3fa50)], [gj.impDay(0x7fd582a3fd30)], [gj.staticIn(0x7fd582a40010)], [gj.pushDingTalk(0x7fd582a402f0)]), filter(nil) 2 - output([gj.clearId(0x7fd582a395c0)], [gj.alarmTitle(0x7fd582a398a0)], [gj.equipmentClass(0x7fd582a39b80)], [gj.maker(0x7fd582a39e60)], [gj.standardCode(0x7fd582a3a140)], [gj.standardName(0x7fd582a3a420)], [gj.utranCell(0x7fd582a3a700)], [gj.eventTime(0x7fd582a3a9e0)], [gj.clearTime(0x7fd582a3acc0)], [gj.dzOrXq(0x7fd582a3afa0)], [gj.gridName(0x7fd582a3b280)], [gj.dzSc(0x7fd582a3b560)], [gj.week(0x7fd582a3b840)], [gj.year(0x7fd582a3bb20)], [gj.standardZs(0x7fd582a3be00)], [gj.gsxzq(0x7fd582a3c0e0)], [gj.cj(0x7fd582a3c3c0)], [gj.dzMinute(0x7fd582a3e630)], [gj.eventDay(0x7fd582a3e910)], [gj.eventH(0x7fd582a3ebf0)], [gj.eventMonth(0x7fd582a3eed0)], [gj.codeOrName(0x7fd582a3f1b0)], [gj.fdz(0x7fd582a3f490)], [gj.gjStandardZs(0x7fd582a3f770)], [gj.ssjxOver(0x7fd582a3fa50)], [gj.impDay(0x7fd582a3fd30)], [gj.staticIn(0x7fd582a40010)], [gj.pushDingTalk(0x7fd582a402f0)]), filter(nil), rowset=256, access([gj.clearId(0x7fd582a395c0)], [gj.alarmTitle(0x7fd582a398a0)], [gj.equipmentClass(0x7fd582a39b80)], [gj.maker(0x7fd582a39e60)], [gj.standardCode(0x7fd582a3a140)], [gj.standardName(0x7fd582a3a420)], [gj.utranCell(0x7fd582a3a700)], [gj.eventTime(0x7fd582a3a9e0)], [gj.clearTime(0x7fd582a3acc0)], [gj.dzOrXq(0x7fd582a3afa0)], [gj.gridName(0x7fd582a3b280)], [gj.dzSc(0x7fd582a3b560)], [gj.week(0x7fd582a3b840)], [gj.year(0x7fd582a3bb20)], [gj.standardZs(0x7fd582a3be00)], [gj.gsxzq(0x7fd582a3c0e0)], [gj.cj(0x7fd582a3c3c0)], [gj.dzMinute(0x7fd582a3e630)], [gj.eventDay(0x7fd582a3e910)], [gj.eventH(0x7fd582a3ebf0)], [gj.eventMonth(0x7fd582a3eed0)], [gj.codeOrName(0x7fd582a3f1b0)], [gj.fdz(0x7fd582a3f490)], [gj.gjStandardZs(0x7fd582a3f770)], [gj.ssjxOver(0x7fd582a3fa50)], [gj.impDay(0x7fd582a3fd30)], [gj.staticIn(0x7fd582a40010)], [gj.pushDingTalk(0x7fd582a402f0)]), partitions(p0), is_index_back=false, range_key([gj.__pk_increment(0x7fd582a4e390)]), 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"."gj"@"SEL$1") OPTIMIZER_FEATURES_ENABLE('4.0.0.0') END_OUTLINE_DATA */ Plan Type: ------------------------------------- REMOTE Optimization Info: ------------------------------------- gj:table_rows:6639783, physical_range_rows:6872792, logical_range_rows:6836241, index_back_rows:0, output_rows:6836241, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[gj], pruned_index_name[eventTime,clearTime,dzOrXq,standardZs,eventDay,eventMonth,clearId,dzMinute,codeOrName,gridName,utranCell,dzOrXq_eventMonth], estimation info[table_id:558786, (table_type:10, version:-1--1--1, logical_rc:6799032, physical_rc:6799032), (table_type:12, version:-1--1--1, logical_rc:26976, physical_rc:41679), (table_type:0, version:-1--1--1, logical_rc:10233, physical_rc:32081)] Parameters: -------------------------------------