explain plan

最新推荐文章于 2024-06-04 06:58:32 发布

shanshuizhizun

最新推荐文章于 2024-06-04 06:58:32 发布

阅读量434

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/shanshuizhizun/article/details/9184079

版权

Oracle 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

explain plan for (select * from emp, dept where emp.deptno = dept.deptno);

select * from table(dbms_xplan.display());

3 result

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 844388907
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Ti
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 14 | 812 | 6 (17)| 00
| 1 | MERGE JOIN | | 14 | 812 | 6 (17)| 00
| 2 | TABLE ACCESS BY INDEX ROWID| DEPT | 4 | 80 | 2 (0)| 00
| 3 | INDEX FULL SCAN | PK_DEPT | 4 | | 1 (0)| 00
|* 4 | SORT JOIN | | 14 | 532 | 4 (25)| 00
| 5 | TABLE ACCESS FULL | EMP | 14 | 532 | 3 (0)| 00
--------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("EMP"."DEPTNO"="DEPT"."DEPTNO")
filter("EMP"."DEPTNO"="DEPT"."DEPTNO")

18 rows selected