zzj@rac1> EXPLAIN PLAN FOR SELECT * FROM T_USER;
Explained.
zzj@rac1> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------
Plan hash value: 2508602004
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 23 | 1817 | 4 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| YANG_T | 23 | 1817 | 4 (0)| 00:00:01 |
----------------------------------------------------------------------------
Note
-----
- dynamic sampling used for this statement (level=2)
12 rows selected.
從下面的查詢結果中可以看出使用EXPLAIN PLAN FOR 查看執行計畫時oracle是沒有執行要查看執行計畫的sql 語句的。
PL/SQL Developer使用explain plan（F5）功能。
