By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 3882305214 |
----------------------------------------- |
| Id | Operation | Name | Rows | |
----------------------------------------- |
| 0 | SELECT STATEMENT | | 2 | |
| 1 | VIEW | | 2 | |
| 2 | UNPIVOT | | | |
| 3 | FAST DUAL | | 1 | |
----------------------------------------- |
PLAN_TABLE_OUTPUT |
---|
Plan hash value: 2083928383 |
----------------------------------------- |
| Id | Operation | Name | Rows | |
----------------------------------------- |
| 0 | SELECT STATEMENT | | 2 | |
| 1 | NESTED LOOPS | | 2 | |
| 2 | FAST DUAL | | 1 | |
| 3 | VIEW | | 2 | |
| 4 | UNION-ALL | | | |
| 5 | FAST DUAL | | 1 | |
| 6 | FAST DUAL | | 1 | |
----------------------------------------- |