add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PLAN_TABLE_OUTPUT
Plan hash value: 1746940330
------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 39 | 2 (50)| 00:00:01 | | |
| 1 | HASH GROUP BY | | 1 | 39 | 2 (50)| 00:00:01 | | |
| 2 | PARTITION HASH SINGLE | | 1 | 39 | 1 (0)| 00:00:01 | 6 | 6 |
| 3 | TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| ORDERS | 1 | 39 | 1 (0)| 00:00:01 | 6 | 6 |
|* 4 | INDEX RANGE SCAN | ORDERS_BY_USER | 1 | | 1 (0)| 00:00:01 | 6 | 6 |
------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
   4 - access("ORDERS"."USER_ID"=42)
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)