explain extended_noaddr
select count(1)  from pos_salesdetail_70 t ,pos_salesh_70 s 
where t.storeId='2c8dba1a3d6868ac8df7645a90ff1d4d' and t.storeSysCode='96870'  
and t.salesId=s.id and s.storeId='2c8dba1a3d6868ac8df7645a90ff1d4d' and s.storeSysCode='96870' and s.SalesTime BETWEEN '2024-03-01 00:00:00'
AND '2024-04-31 23:59:59';


=================================================================
|ID|OPERATOR            |NAME             |EST.ROWS|EST.TIME(us)|
-----------------------------------------------------------------
|0 |SCALAR GROUP BY     |                 |1       |1412531     |
|1 |└─HASH JOIN         |                 |550272  |1402557     |
|2 |  ├─TABLE RANGE SCAN|s(idx_salesh_cb2)|119742  |6032        |
|3 |  └─TABLE FULL SCAN |t                |3425214 |392241      |
=================================================================
Outputs & filters:
-------------------------------------
  0 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256
      group(nil), agg_func([T_FUN_COUNT(*)])
  1 - output(nil), filter(nil), rowset=256
      equal_conds([t.SalesId = s.Id]), other_conds(nil)
  2 - output([s.Id]), filter(nil), rowset=256
      access([s.Id]), partitions(p0)
      is_index_back=false, is_global_index=false, 
      range_key([s.StoreId], [s.StoreSysCode], [s.SalesTime], [s.SalesNo], [s.Id]), range(2c8dba1a3d6868ac8df7645a90ff1d4d,96870,2024-03-01 00:00:00,MIN,
      MIN ; 2c8dba1a3d6868ac8df7645a90ff1d4d,96870,2024-04-31 23:59:59,MAX,MAX), 
      range_cond([s.StoreId = '2c8dba1a3d6868ac8df7645a90ff1d4d'], [s.StoreSysCode = '96870'], [s.SalesTime >= '2024-03-01 00:00:00'], [s.SalesTime <= '2024-04-31 
      23:59:59'])
  3 - output([t.SalesId]), filter([t.StoreId = '2c8dba1a3d6868ac8df7645a90ff1d4d'], [t.StoreSysCode = '96870']), rowset=256
      access([t.StoreId], [t.StoreSysCode], [t.SalesId]), partitions(p0)
      is_index_back=false, is_global_index=false, filter_before_indexback[false,false], 
      range_key([t.id]), range(MIN ; MAX)always true
Used Hint:
-------------------------------------
  /*+
      
  */
Qb name trace:
-------------------------------------
  stmt_id:0, stmt_type:T_EXPLAIN 
  stmt_id:1, SEL$1 > SEL$EA493D33
Outline Data: 
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      LEADING(@"SEL$EA493D33" ("s"@"SEL$1" "t"@"SEL$1"))
      USE_HASH(@"SEL$EA493D33" "t"@"SEL$1")
      INDEX(@"SEL$EA493D33" "s"@"SEL$1" "idx_salesh_cb2")
      FULL(@"SEL$EA493D33" "t"@"SEL$1")
      SIMPLIFY_GROUP_BY(@"SEL$1")
      OPTIMIZER_FEATURES_ENABLE('4.3.3.0')
      END_OUTLINE_DATA
  */
Optimization Info:
-------------------------------------
  s:
      table_rows:746995
      physical_range_rows:119742
      logical_range_rows:119742
      index_back_rows:0
      output_rows:119742
      table_dop:1
      dop_method:Table DOP
      avaiable_index_name:[idx_posSalesh_storeIdReturnSalesId, idx_pos_salesh_70_custid, idx_pos_salesh_70_storeid_salestype, idx_pos_salesh_70_storesyscode, idx_pos_salesh_70_sysupdatetime, idx_salesh_cb2, idx_salesh_salesdate, idx_salesh_salesmonth, idx_salesh_salesno, idx_salesh_salestime, idx_salesh_salesyear, idx_salesh_storeidsalesdate, idx_salesh_storeid_salesdate, idx_salesh_storeid_salestime, pos_salesh_70]
      pruned_index_name:[idx_posSalesh_storeIdReturnSalesId, idx_pos_salesh_70_custid, idx_pos_salesh_70_storeid_salestype, idx_pos_salesh_70_sysupdatetime, idx_salesh_salesdate, idx_salesh_salesmonth, idx_salesh_salesno, idx_salesh_salestime, idx_salesh_salesyear, idx_salesh_storeidsalesdate, idx_salesh_storeid_salesdate, idx_salesh_storeid_salestime]
      stats info:[version=1729980597376403, is_locked=0, is_expired=0]
      dynamic sampling level:0
      estimation method:[OPTIMIZER STATISTICS, STORAGE]
  t:
      table_rows:3425356
      physical_range_rows:3425357
      logical_range_rows:3425357
      index_back_rows:0
      output_rows:3425148
      table_dop:1
      dop_method:Table DOP
      avaiable_index_name:[idx_salesdetail_cb1, idx_salesdetail_cb2, idx_salesdetail_cb3, idx_salesdetail_cb6, idx_salesdetail_salesId, idx_salesdetail_salesmonth, idx_salesdetail_salesyear, idx_salesdetail_storeIdsalesDate, idx_salesdetail_x2, idx_stocker_storeid_selfnum, pos_salesdetail_70]
      pruned_index_name:[idx_salesdetail_cb1, idx_salesdetail_cb3, idx_salesdetail_salesId, idx_salesdetail_salesmonth, idx_salesdetail_salesyear, idx_salesdetail_storeIdsalesDate, idx_stocker_storeid_selfnum]
      stats info:[version=1729981941745382, is_locked=0, is_expired=0]
      dynamic sampling level:0
      estimation method:[OPTIMIZER STATISTICS, STORAGE]
  Plan Type:
      LOCAL
  Note:
      Degree of Parallelisim is 1 because of table property