SQL> explain plan for
2 select 1 from dual;
Explained.
SQL> select * from table(DBMS_XPLAN.Display);
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1388734953
-----------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-----------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2 (0)| 00:00:01 |
| 1 | FAST DUAL | | 1 | 2 (0)| 00:00:01 |
-----------------------------------------------------------------
8 rows selected.
SQL>
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/665949/viewspace-736938/
,如需转载,请注明出处,否则将追究法律责任。