计划详情
SQL: select /*+ use_nl(b a) index(a ws_log_busi_id) */a.flow_id from ddzx_jzjk_log.ws_log a , excel_data b where a.busi_id = b.col_9
查看格式化信息
================================================================
|ID|OPERATOR            |NAME             |EST. ROWS|COST      |
----------------------------------------------------------------
|0 |NESTED-LOOP JOIN    |                 |797      |5406239007|
|1 | PX COORDINATOR     |                 |100      |111       |
|2 |  EXCHANGE OUT DISTR|:EX10000         |100      |51        |
|3 |   TABLE SCAN       |b(idx_col9)      |100      |51        |
|4 | MATERIAL           |                 |269612435|1182022810|
|5 |  TABLE SCAN        |a(ws_log_busi_id)|269612435|1158180749|
================================================================

Outputs & filters: 
-------------------------------------
  0 - output([a.flow_id(0x7dfa78873fb0)]), filter(nil), 
      conds([a.busi_id(0x7dfa788735f0) = b.col_9(0x7dfa788738e0)(0x7dfa78872ed0)]), nl_params_(nil), batch_join=false
  1 - output([b.col_9(0x7dfa788738e0)]), filter(nil)
  2 - output([b.col_9(0x7dfa788738e0)]), filter(nil), is_single, dop=1
  3 - output([b.col_9(0x7dfa788738e0)]), filter(nil), 
      access([b.col_9(0x7dfa788738e0)]), partitions(p0), 
      is_index_back=false, 
      range_key([b.col_9(0x7dfa788738e0)], [b.id(0x7dfa78891080)]), range(MIN,MIN ; MAX,MAX)always true
  4 - output([a.flow_id(0x7dfa78873fb0)], [a.busi_id(0x7dfa788735f0)]), filter(nil)
  5 - output([a.busi_id(0x7dfa788735f0)], [a.flow_id(0x7dfa78873fb0)]), filter(nil), 
      access([a.busi_id(0x7dfa788735f0)], [a.flow_id(0x7dfa78873fb0)]), partitions(p0), 
      is_index_back=true, 
      range_key([a.__substr255_27(0x7dfa7888a580)], [a.flow_id(0x7dfa78873fb0)], [a.create_time(0x7dfa7888a870)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true

Used Hint:
-------------------------------------
  /*+
      USE_NL(@"SEL$1" ("ddzx_jzjk_log.a"@"SEL$1" ))
      INDEX(@"SEL$1" "ddzx_jzjk_log.a"@"SEL$1" "ws_log_busi_id")
  */

Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      LEADING(@"SEL$1" ("zqddzx.b"@"SEL$1" "ddzx_jzjk_log.a"@"SEL$1" ))
      USE_NL(@"SEL$1" ("ddzx_jzjk_log.a"@"SEL$1" ))
      USE_NL_MATERIALIZATION(@"SEL$1" ("ddzx_jzjk_log.a"@"SEL$1" ))
      INDEX(@"SEL$1" "zqddzx.b"@"SEL$1" "idx_col9")
      INDEX(@"SEL$1" "ddzx_jzjk_log.a"@"SEL$1" "ws_log_busi_id")
      END_OUTLINE_DATA
  */

Plan Type:
-------------------------------------
DISTRIBUTED

Optimization Info:
-------------------------------------




b:table_rows:100, physical_range_rows:100, logical_range_rows:100, index_back_rows:0, output_rows:100, est_method:remote_storage, optimization_method=cost_based, avaiable_index_name[idx_col9], pruned_index_name[excel_data], estimation info[table_id:1101710652280937, (table_type:1, version:0-1680183010094410-1680183010094410, logical_rc:100, physical_rc:100), (table_type:7, version:1680183000512932-1680183000512932-1680183047390834, logical_rc:0, physical_rc:0), (table_type:7, version:1680183047390834-1680183047390834-1680230487021210, logical_rc:0, physical_rc:0), (table_type:7, version:1680230487021210-1680230487021210-1680250058724207, logical_rc:0, physical_rc:0), (table_type:5, version:1680230487021210-1680230487021210-1680250058724207, logical_rc:0, physical_rc:0), (table_type:0, version:1680250058724207-1680250058724207-9223372036854775807, logical_rc:0, physical_rc:0)]


a:table_rows:265964267, physical_range_rows:269612527, logical_range_rows:269612435, index_back_rows:269612435, output_rows:269612435, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[ws_log_busi_id], pruned_index_name[auto_shard_key_flow_id,trans_ido,ws_log_create_time,ws_log_operate_name,ws_log_trans_ido,ws_log], estimation info[table_id:1101710651545699, (table_type:1, version:0-1680183010094410-1680183010094410, logical_rc:265964267, physical_rc:265964267), (table_type:7, version:1680183000930253-1680183000930253-1680183047279171, logical_rc:760, physical_rc:760), (table_type:4, version:1680183047279171-1680183047279171-1680249200666602, logical_rc:2344504, physical_rc:2344596), (table_type:7, version:1680249200666602-1680249200666602-1680252979224801, logical_rc:509417, physical_rc:509417), (table_type:7, version:1680252979224801-1680252979224801-1680257376104609, logical_rc:506917, physical_rc:506917), (table_type:5, version:1680252979224801-1680252979224801-1680257376104609, logical_rc:0, physical_rc:0), (table_type:0, version:1680257376104609-1680257376104609-9223372036854775807, logical_rc:286570, physical_rc:286570)]
Parameters
-------------------------------------