add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
256 rows affected
1 rows affected
259 rows affected
1 rows affected
A COUNT(*)
2 2
1 516
SUM(A)
4
PLAN_TABLE_OUTPUT
SQL_ID cw3ag7gkjpfb4, child number 0
-------------------------------------
select /*+ gather_plan_statistics */ sum(A) from DEMO where A=2
Plan hash value: 2842824019
---------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
---------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.01 | 2 |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.01 | 2 |
|* 2 | INDEX RANGE SCAN| DEMO_AB | 1 | 2 | 2 |00:00:00.01 | 2 |
---------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   2 - access("A"=2)
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)
SUM(B)
0
PLAN_TABLE_OUTPUT
SQL_ID 65cjxtvwydbpc, child number 0
-------------------------------------
select /*+ gather_plan_statistics */ sum(B) from DEMO where A=2
Plan hash value: 2842824019
---------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
---------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.01 | 2 |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.01 | 2 |
|* 2 | INDEX RANGE SCAN| DEMO_AB | 1 | 2 | 2 |00:00:00.01 | 2 |
---------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   2 - access("A"=2)
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)
SUM(C)
0
PLAN_TABLE_OUTPUT
SQL_ID 1yukcgvh7d3x3, child number 0
-------------------------------------
select /*+ gather_plan_statistics */ sum(C) from DEMO where A=2
Plan hash value: 1078896418
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 1 |00:00:00.01 | 3 |
| 1 | SORT AGGREGATE | | 1 | 1 | 1 |00:00:00.01 | 3 |
| 2 | TABLE ACCESS BY INDEX ROWID BATCHED| DEMO | 1 | 2 | 2 |00:00:00.01 | 3 |
|* 3 | INDEX RANGE SCAN | DEMO_AB | 1 | 2 | 2 |00:00:00.01 | 2 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   3 - access("A"=2)
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)