=======================================================================
|ID|OPERATOR                     |NAME          |EST.ROWS|EST.TIME(us)|
-----------------------------------------------------------------------
|0 |SCALAR GROUP BY              |              |1       |351445      |
|1 |└─HASH JOIN                  |              |28276   |350495      |
|2 |  ├─PX COORDINATOR           |              |28632   |165214      |
|3 |  │ └─EXCHANGE OUT DISTR     |:EX10000      |28632   |152145      |
|4 |  │   └─PX PARTITION ITERATOR|              |28632   |122815      |
|5 |  │     └─TABLE RANGE SCAN   |sl(index_p_id)|28632   |122815      |
|6 |  └─TABLE FULL SCAN          |sinfo         |1109814 |76184       |
=======================================================================
Outputs & filters:
-------------------------------------
  0 - output([sl.p_id(0x7fe0ee0320f0)], [sl.store_acct_id(0x7fe0ee022300)], [CASE WHEN T_FUN_MAX(sinfo.is_sale(0x7fe0ee036670))(0x7fe0ee0335d0) = 0(0x7fe0ee033fc0) 
      THEN 1 WHEN T_FUN_MIN(sinfo.is_sale(0x7fe0ee036670))(0x7fe0ee0349c0) != T_FUN_MAX(sinfo.is_sale(0x7fe0ee036670))(0x7fe0ee0335d0)(0x7fe0ee035820) THEN 0 
      ELSE 2 END(0x7fe0ee032d70)]), filter(nil), rowset=256
      group(nil), agg_func([T_FUN_MAX(sinfo.is_sale(0x7fe0ee036670))(0x7fe0ee0335d0)], [T_FUN_MIN(sinfo.is_sale(0x7fe0ee036670))(0x7fe0ee0349c0)])
  1 - output([sinfo.is_sale(0x7fe0ee036670)], [sl.p_id(0x7fe0ee0320f0)], [sl.store_acct_id(0x7fe0ee022300)]), filter(nil), rowset=256
      equal_conds([sl.prod_s_id(0x7fe0ee030a60) = sinfo.id(0x7fe0ee030d90)(0x7fe0ee0302d0)]), other_conds(nil)
  2 - output([sl.p_id(0x7fe0ee0320f0)], [sl.store_acct_id(0x7fe0ee022300)], [sl.prod_s_id(0x7fe0ee030a60)]), filter(nil), rowset=256
  3 - output([sl.p_id(0x7fe0ee0320f0)], [sl.store_acct_id(0x7fe0ee022300)], [sl.prod_s_id(0x7fe0ee030a60)]), filter(nil), rowset=256
      dop=1
  4 - output([sl.store_acct_id(0x7fe0ee022300)], [sl.prod_s_id(0x7fe0ee030a60)], [sl.p_id(0x7fe0ee0320f0)]), filter(nil), rowset=256
      force partition granule
  5 - output([sl.store_acct_id(0x7fe0ee022300)], [sl.prod_s_id(0x7fe0ee030a60)], [sl.p_id(0x7fe0ee0320f0)]), filter(nil), rowset=256
      access([sl.id(0x7fe0ee039d20)], [sl.store_acct_id(0x7fe0ee022300)], [sl.prod_s_id(0x7fe0ee030a60)], [sl.p_id(0x7fe0ee0320f0)]), partitions(p[0-63])
      is_index_back=true, is_global_index=false, 
      range_key([sl.p_id(0x7fe0ee0320f0)], [sl.id(0x7fe0ee039d20)], [sl.store_acct_id(0x7fe0ee022300)]), range(370533393,MIN,MIN ; 370533393,MAX,MAX), 
      range_cond([sl.p_id(0x7fe0ee0320f0) = 370533393(0x7fe0ee1bb2c0)])
  6 - output([sinfo.id(0x7fe0ee030d90)], [sinfo.is_sale(0x7fe0ee036670)]), filter(nil), rowset=256
      access([sinfo.id(0x7fe0ee030d90)], [sinfo.is_sale(0x7fe0ee036670)]), partitions(p0)
      is_index_back=false, is_global_index=false, 
      range_key([sinfo.id(0x7fe0ee030d90)]), 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
      LEADING(@"SEL$1" ("trade_online"."sl"@"SEL$1" "trade_online"."sinfo"@"SEL$1"))
      USE_HASH(@"SEL$1" "trade_online"."sinfo"@"SEL$1")
      PQ_DISTRIBUTE(@"SEL$1" "trade_online"."sinfo"@"SEL$1" LOCAL LOCAL)
      INDEX(@"SEL$1" "sl"@"SEL$1" "index_p_id")
      FULL(@"SEL$1" "sinfo"@"SEL$1")
      OPTIMIZER_FEATURES_ENABLE('4.2.2.0')
      END_OUTLINE_DATA
  */
Optimization Info:
-------------------------------------
  sl:
      table_rows:227510664
      physical_range_rows:28632
      logical_range_rows:28632
      index_back_rows:28632
      output_rows:28632
      table_dop:1
      dop_method:Table DOP
      avaiable_index_name:[index_p_id, index_store_sub_id, idx_acct_id, idx_shop_sku, index_prod_s_sku, index_store_s_sku, idx_prod_s_id, prod_sync_s_lazada]
      pruned_index_name:[index_store_sub_id, idx_acct_id, idx_shop_sku, index_prod_s_sku, index_store_s_sku]
      stats version:0
      dynamic sampling level:1
      estimation method:[DYNAMIC SAMPLING FULL]
  sinfo:
      table_rows:1109733
      physical_range_rows:1176142
      logical_range_rows:1109814
      index_back_rows:0
      output_rows:1109814
      table_dop:1
      dop_method:Table DOP
      avaiable_index_name:[idx_s_sku, idx_remark, index_p_id, idx_purchase_channel, idx_buyer, idx_is_sale_is_combination, prod_s_info]
      pruned_index_name:[idx_s_sku, idx_remark, index_p_id, idx_purchase_channel, idx_buyer, idx_is_sale_is_combination]
      stats version:1723612751712767
      dynamic sampling level:0
      estimation method:[OPTIMIZER STATISTICS, STORAGE]
  Plan Type:
      DISTRIBUTED
  Note:
      Degree of Parallelisim is 1 because of table property