SQL> select distinct employee_id,first_name from test1;
107 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 255531131
------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 6647K| 158M| | 67481 (1)| 00:13:30 |
| 1 | HASH UNIQUE | | 6647K| 158M| 229M| 67481 (1)| 00:13:30 |
| 2 | TABLE ACCESS FULL| TEST1 | 6647K| 158M| | 19570 (1)| 00:03:55 |
------------------------------------------------------------------------------------
Note
-----
- dynamic sampling used for this statement (level=2)
Statistics
----------------------------------------------------------
4 recursive calls
0 db block gets
group by 替代distinct
最新推荐文章于 2023-03-16 14:08:09 发布