Wednesday, October 9, 2013
How to get explain plan and predicate information while running the SQL Statement
SQL> set autotrace traceonly explain
SQL> select sysdate from dual ;
Execution Plan
----------------------------------------------------------
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 |
-----------------------------------------------------------------
SQL>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment