By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 2202698099 |
-------------------------------------------------------------------------------- |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
-------------------------------------------------------------------------------- |
| 0 | SELECT STATEMENT | | 6 | 138 | 15 (0)| 00:00:01 | |
| 1 | WINDOW SORT | | 6 | 138 | 15 (0)| 00:00:01 | |
| 2 | VIEW | | 6 | 138 | 15 (0)| 00:00:01 | |
| 3 | UNION-ALL | | | | | | |
|* 4 | TABLE ACCESS FULL| MYTABLE | 1 | 23 | 3 (0)| 00:00:01 | |
|* 5 | TABLE ACCESS FULL| MYTABLE | 1 | 23 | 3 (0)| 00:00:01 | |
|* 6 | TABLE ACCESS FULL| MYTABLE | 1 | 23 | 3 (0)| 00:00:01 | |
|* 7 | TABLE ACCESS FULL| MYTABLE | 1 | 23 | 3 (0)| 00:00:01 | |
|* 8 | TABLE ACCESS FULL| MYTABLE | 2 | 46 | 3 (0)| 00:00:01 | |
-------------------------------------------------------------------------------- |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
4 - filter("COND1"='Yes') |
5 - filter("COND2"='Yes') |
6 - filter("COND3"='Yes') |
7 - filter("COND4"='Yes') |
8 - filter("COND5"='Yes') |
Note |
----- |
- dynamic sampling used for this statement (level=2) |