=======================================================================
|ID|OPERATOR               |NAME                |EST.ROWS|EST.TIME(us)|
-----------------------------------------------------------------------
|0 |NESTED-LOOP OUTER JOIN |                    |9284    |232648      |
|1 |├─TABLE RANGE SCAN     |pd(idx_packing_time)|9284    |39126       |
|2 |└─DISTRIBUTED TABLE GET|pom                 |1       |21          |
=======================================================================
Outputs & filters:
-------------------------------------
  0 - output([pd.id(0x7f7475a29f50)], [pom.id(0x7f7475a23dd0)]), filter(nil), rowset=256
      conds(nil), nl_params_([pd.order_id(0x7f7475a23aa0)(:0)]), use_batch=false
  1 - output([pd.id(0x7f7475a29f50)], [pd.order_id(0x7f7475a23aa0)]), filter(nil), rowset=256
      access([pd.id(0x7f7475a29f50)], [pd.order_id(0x7f7475a23aa0)]), partitions(p0)
      is_index_back=true, is_global_index=false, 
      range_key([pd.packing_time(0x7f7475a28de0)], [pd.id(0x7f7475a29f50)]), range(2024-05-27 17:15:38.000000,MIN ; 2024-06-26 17:15:38.000000,MAX), 
      range_cond([pd.packing_time(0x7f7475a28de0) >= date_add(current_timestamp()(0x7f7475b13900), cast(-30, VARCHAR(1048576))(0x7f7475b141e0), 4)(0x7f7475b13020)(0x7f7475b12720)],
       [pd.packing_time(0x7f7475a28de0) <= current_timestamp()(0x7f7475b15c60)(0x7f7475b15390)])
  2 - output([pom.id(0x7f7475a23dd0)]), filter(nil), rowset=256
      access([pom.id(0x7f7475a23dd0)]), partitions(p0)
      is_index_back=false, is_global_index=false, 
      range_key([pom.id(0x7f7475a23dd0)]), range(MIN ; MAX), 
      range_cond([:0 = pom.id(0x7f7475a23dd0)(0x7f7475b16540)])
Used Hint:
-------------------------------------
  /*+
      
  */
Qb name trace:
-------------------------------------
  stmt_id:0, stmt_type:T_EXPLAIN 
  stmt_id:1, SEL$1
Outline Data: 
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      LEADING(@"SEL$1" ("trade_online"."pd"@"SEL$1" "trade_online"."pom"@"SEL$1"))
      USE_NL(@"SEL$1" "trade_online"."pom"@"SEL$1")
      INDEX(@"SEL$1" "pd"@"SEL$1" "idx_packing_time")
      FULL(@"SEL$1" "pom"@"SEL$1")
      USE_DAS(@"SEL$1" "pom"@"SEL$1")
      OPTIMIZER_FEATURES_ENABLE('4.2.2.0')
      END_OUTLINE_DATA
  */
Optimization Info:
-------------------------------------
  pd:
      table_rows:42827882
      physical_range_rows:9284
      logical_range_rows:9284
      index_back_rows:9284
      output_rows:9284
      table_dop:1
      dop_method:Table DOP
      avaiable_index_name:[index_sku_batch_no, idx_batch_no, idx_check_time, idx_pick_user_id, idx_batch_no_expect_pick_user_id, idx_order_id, idx_packing_time, idx_pick_time, idx_order_detail_id, plat_order_pick_detail_his]
      pruned_index_name:[index_sku_batch_no, idx_batch_no, idx_check_time, idx_pick_user_id, idx_batch_no_expect_pick_user_id, idx_pick_time, idx_order_detail_id]
      stats version:1719368068337560
      dynamic sampling level:0
      estimation method:[OPTIMIZER STATISTICS, STORAGE]
  pom:
      table_rows:5908142
      physical_range_rows:1
      logical_range_rows:1
      index_back_rows:0
      output_rows:1
      table_dop:1
      dop_method:DAS DOP
      avaiable_index_name:[index_tracking_no, idx_plat_code_order_time, idx_remain_time_plat_code, idx_store_acct_id_order_time_cn, idx_process_status, idx_buyer, idx_store_acct_id, idx_shipping_time, idx_modify_time, idx_order_time, idx_logis_agent_tracking_no, idx_plat_transaction_id, idx_plat_order_id, plat_order_main]
      pruned_index_name:[index_tracking_no, idx_plat_code_order_time, idx_remain_time_plat_code, idx_store_acct_id_order_time_cn, idx_process_status, idx_buyer, idx_store_acct_id, idx_shipping_time, idx_modify_time, idx_order_time, idx_logis_agent_tracking_no, idx_plat_transaction_id, idx_plat_order_id]
      stats version:1719368757666909
      dynamic sampling level:0
      estimation method:[OPTIMIZER STATISTICS]
  Plan Type:
      LOCAL
  Note:
      Degree of Parallelisim is 1 because of table property