SQL: select a.flow_id from excel_data b join ddzx_log.ws_log a on a.busi_id = b.col_9 ;
查看格式化信息
=========================================================
|ID|OPERATOR            |NAME       |EST. ROWS|COST     |
---------------------------------------------------------
|0 |HASH JOIN           |           |795      |480661525|
|1 | TABLE SCAN         |b(idx_col9)|100      |51       |
|2 | PX COORDINATOR     |           |263934622|309477668|
|3 |  EXCHANGE OUT DISTR|:EX10000   |263934622|142475741|
|4 |   TABLE SCAN       |a          |263934622|142475741|
=========================================================

Outputs & filters: 
-------------------------------------
  0 - output([a.flow_id(0x7ed870b407f0)]), filter(nil), 
      equal_conds([a.busi_id(0x7ed870b3fe30) = b.col_9(0x7ed870b40120)(0x7ed870b3f710)]), other_conds(nil)
  1 - output([b.col_9(0x7ed870b40120)]), filter(nil), 
      access([b.col_9(0x7ed870b40120)]), partitions(p0), 
      is_index_back=false, 
      range_key([b.col_9(0x7ed870b40120)], [b.id(0x7ed870b56e00)]), range(MIN,MIN ; MAX,MAX)always true
  2 - output([a.busi_id(0x7ed870b3fe30)], [a.flow_id(0x7ed870b407f0)]), filter(nil)
  3 - output([a.busi_id(0x7ed870b3fe30)], [a.flow_id(0x7ed870b407f0)]), filter(nil), is_single, dop=1
  4 - output([a.busi_id(0x7ed870b3fe30)], [a.flow_id(0x7ed870b407f0)]), filter(nil), 
      access([a.busi_id(0x7ed870b3fe30)], [a.flow_id(0x7ed870b407f0)]), partitions(p0), 
      is_index_back=false, 
      range_key([a.flow_id(0x7ed870b407f0)], [a.create_time(0x7ed870b5c680)]), range(MIN,MIN ; MAX,MAX)always true

Used Hint:
-------------------------------------
  /*+
  */

Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      LEADING(@"SEL$1" ("zqddzx.b"@"SEL$1" "ddzx_log.a"@"SEL$1" ))
      USE_HASH(@"SEL$1" ("ddzx_log.a"@"SEL$1" ))
      INDEX(@"SEL$1" "zqddzx.b"@"SEL$1" "idx_col9")
      FULL(@"SEL$1" "ddzx_log.a"@"SEL$1")
      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:local_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-1680148329789326-1680148329789326, logical_rc:100, physical_rc:100), (table_type:7, version:1680141051311531-1680141051311531-1680151821529787, logical_rc:0, physical_rc:0), (table_type:5, version:1680141051311531-1680141051311531-1680151821529787, logical_rc:0, physical_rc:0), (table_type:0, version:1680151821529787-1680151821529787-9223372036854775807, logical_rc:0, physical_rc:0)]



a:table_rows:261958049, physical_range_rows:263934622, logical_range_rows:263934622, index_back_rows:0, output_rows:263934622, est_method:remote_storage, optimization_method=cost_based, avaiable_index_name[ws_log], pruned_index_name[auto_shard_key_flow_id,trans_ido,ws_log_busi_id,ws_log_create_time,ws_log_operate_name,ws_log_trans_ido], estimation info[table_id:1101710651545696, (table_type:1, version:0-1680096611476881-1680096611476881, logical_rc:261958049, physical_rc:261958049), (table_type:7, version:1680096605133919-1680096605133919-1680096651732804, logical_rc:666, physical_rc:666), (table_type:7, version:1680096651732804-1680096651732804-1680154146905069, logical_rc:1785859, physical_rc:1785859), (table_type:5, version:1680141831161539-1680141831161539-1680154146905069, logical_rc:0, physical_rc:0), (table_type:0, version:1680154146905069-1680154146905069-9223372036854775807, logical_rc:190048, physical_rc:190048)]
Parameters
-------------------------------------