By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
26 rows affected
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 3463100252 |
------------------------------------------------------------------------------- |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
------------------------------------------------------------------------------- |
| 0 | SELECT STATEMENT | | 1 | 4 | 3 (0)| 00:00:01 | |
|* 1 | COUNT STOPKEY | | | | | | |
|* 2 | TABLE ACCESS FULL| EMPLOYEE | 1 | 4 | 3 (0)| 00:00:01 | |
------------------------------------------------------------------------------- |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
1 - filter(ROWNUM<5) |
2 - filter("FIRSTNAME"='X') |
Note |
----- |
- dynamic sampling used for this statement (level=2) |
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 3463100252 |
------------------------------------------------------------------------------- |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
------------------------------------------------------------------------------- |
| 0 | SELECT STATEMENT | | 1 | 4 | 3 (0)| 00:00:01 | |
|* 1 | COUNT STOPKEY | | | | | | |
|* 2 | TABLE ACCESS FULL| EMPLOYEE | 1 | 4 | 3 (0)| 00:00:01 | |
------------------------------------------------------------------------------- |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
1 - filter(ROWNUM<5) |
2 - filter("FIRSTNAME"='X') |
Note |
----- |
- dynamic sampling used for this statement (level=2) |