查询当前SQL执行计划

最新推荐文章于 2023-04-29 12:30:00 发布

launch_225

最新推荐文章于 2023-04-29 12:30:00 发布

阅读量800

点赞数

分类专栏： SQL 文章标签： sql table access

本文链接：https://blog.csdn.net/launch_225/article/details/7595713

版权

SQL 专栏收录该内容

48 篇文章 0 订阅

订阅专栏

SQL> explain plan for
2 select * from dual;

Explained.

SQL> select * from dual;

D
-
X

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

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 3543395131

--------------------------------------------------------------------------
| Id | Operation         | Name | Rows | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     1 |     2 |     2   (0)| 00:00:01 |
|   1 | TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------

8 rows selected.