=================================================================== |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| ------------------------------------------------------------------- |0 |SCALAR GROUP BY | |1 |237586 | |1 |└─TABLE FULL SCAN|WF004_FLOWRUN_20220513|2892253 |140403 | =================================================================== Outputs & filters: ------------------------------------- 0 - output([T_FUN_SUM(WF004_FLOWRUN_20220513.WC004_STATUS(0x14f25a61fc80))(0x14f25a6205b0) / cast(T_FUN_COUNT(WF004_FLOWRUN_20220513.WC004_STATUS(0x14f25a61fc80))(0x14f25a6209d0), DECIMAL(20, 0))(0x14f25a621750)(0x14f25a620df0)]), filter(nil), rowset=256 group(nil), agg_func([T_FUN_SUM(WF004_FLOWRUN_20220513.WC004_STATUS(0x14f25a61fc80))(0x14f25a6205b0)], [T_FUN_COUNT(WF004_FLOWRUN_20220513.WC004_STATUS(0x14f25a61fc80))(0x14f25a6209d0)]) 1 - output([WF004_FLOWRUN_20220513.WC004_STATUS(0x14f25a61fc80)]), filter(nil), rowset=256 access([WF004_FLOWRUN_20220513.WC004_STATUS(0x14f25a61fc80)]), partitions(p0) is_index_back=false, is_global_index=false, range_key([WF004_FLOWRUN_20220513.__pk_increment(0x14f25a620280)]), 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 FULL(@"SEL$1" "obkv_redis"."WF004_FLOWRUN_20220513"@"SEL$1") OPTIMIZER_FEATURES_ENABLE('4.2.5.0') END_OUTLINE_DATA */ Optimization Info: ------------------------------------- WF004_FLOWRUN_20220513: table_rows:2892253 physical_range_rows:2892253 logical_range_rows:2892253 index_back_rows:0 output_rows:2892253 table_dop:1 dop_method:Table DOP avaiable_index_name:[index1, WF004_FLOWRUN_20220513] pruned_index_name:[index1] stats info:[version=2024-11-29 22:00:47.449235, 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