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)
Rows selected.
You can see from the query results below that Oracle did not execute the SQL statement to view the execution plan when using explain plan for viewing execution plans.
Pl/sql developer uses the explain plan (F5) feature.
