=============================================================================================== |ID|OPERATOR |NAME |EST. ROWS|COST | ----------------------------------------------------------------------------------------------- |0 |LIMIT | |1 |396198| |1 | PX COORDINATOR MERGE SORT | |1 |396198| |2 | EXCHANGE OUT DISTR |:EX10000 |1 |396198| |3 | LIMIT | |1 |396198| |4 | TOP-N SORT | |1 |396198| |5 | PX PARTITION ITERATOR | |1 |396198| |6 | TABLE SCAN |gic_emission_mobile(idx_tenant_id_enent_time)|1 |396198| =============================================================================================== Outputs & filters: ------------------------------------- 0 - output([gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter(nil), limit(100), offset(nil) 1 - output([gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter(nil), sort_keys([gic_emission_mobile.id(0x7fa4a4163410), ASC]) 2 - output([gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter(nil), dop=1 3 - output([gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter(nil), limit(100), offset(nil) 4 - output([gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter(nil), sort_keys([gic_emission_mobile.id(0x7fa4a4163410), ASC]), topn(100) 5 - output([gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter(nil), force partition granule, asc. 6 - output([gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), filter([gic_emission_mobile.id(0x7fa4a4163410) > 4054565661(0x7fa4a4162d60)], [gic_emission_mobile.source_name(0x7fa4a4165dc0) = 'jieyi.20240509-bus.csv'(0x7fa4a4165710)]), access([gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)], [gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.source_name(0x7fa4a4165dc0)], [gic_emission_mobile.app_id(0x7fa4a4166600)], [gic_emission_mobile.event_id(0x7fab5d1e6450)], [gic_emission_mobile.emission(0x7fab5d1e6c90)], [gic_emission_mobile.region(0x7fab5d1e7210)]), partitions(p15sp[0-31]), is_index_back=true, filter_before_indexback[true,false], range_key([gic_emission_mobile.tenant_id(0x7fa4a4158730)], [gic_emission_mobile.event_time(0x7fa4a41642b0)], [gic_emission_mobile.id(0x7fa4a4163410)], [gic_emission_mobile.mobile_sha256(0x7fa4a41617c0)]), range(43,2024-05-07 16:00:00.000000,4054565661,MAX ; 43,2024-05-08 15:59:59.000000,MAX,MAX), range_cond([gic_emission_mobile.tenant_id(0x7fa4a4158730) = 43(0x7fa4a4161fb0)], [gic_emission_mobile.event_time(0x7fa4a41642b0) >= ?(0x7fa4a4163c00)], [gic_emission_mobile.event_time(0x7fa4a41642b0) <= ?(0x7fa4a4164b30)]) Used Hint: ------------------------------------- /*+ */ Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA INDEX(@"SEL$1" "gic_trade.gic_emission_mobile"@"SEL$1" "idx_tenant_id_enent_time") END_OUTLINE_DATA */ Plan Type: ------------------------------------- DISTRIBUTED Optimization Info: ------------------------------------- gic_emission_mobile:table_rows:3807011, physical_range_rows:1272352, logical_range_rows:1272352, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[idx_tenant_id_enent_time,gic_emission_mobile], pruned_index_name[uk_tenant_id_mobile_event_id,idx_mobile_sha256,idx_tenant_id_region_remain_emission_event_time,idx_event_month], estimation info[table_id:1100611139454211, (table_type:1, version:0-1715191210404535-1715191210404535, logical_rc:0, physical_rc:0), (table_type:7, version:1715191201059139-1715191210404535-1715191228873141, logical_rc:0, physical_rc:0), (table_type:7, version:1715191228873141-1715245360403668-1715245360403668, logical_rc:39761, physical_rc:39761), (table_type:5, version:1715238351524650-1715245360403668-1715245360403668, logical_rc:0, physical_rc:0), (table_type:0, version:1715245360403668-1715245360403668-9223372036854775807, logical_rc:0, physical_rc:0)] Parameters ------------------------------------- {obj:{"TIMESTAMP":"2024-05-07 16:00:00.000000"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"TIMESTAMP", collation:"binary", coercibility:"NUMERIC"}}, {obj:{"TIMESTAMP":"2024-05-08 15:59:59.000000"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"TIMESTAMP", collation:"binary", coercibility:"NUMERIC"}}