SHARE
TWEET

Untitled

a guest Jul 18th, 2013 34 Never
  1. explain plan for
  2. select * from person
  3. where person_id = 3
  4. ;
  5.  
  6. plan FOR succeeded.
  7.  
  8. select * from table( dbms_xplan.display );
  9.  
  10. Plan hash value: 3101872853
  11.  
  12. --------------------------------------------------------------------------------------------
  13. | Id  | Operation                   | Name         | Rows  | Bytes | Cost (%CPU)| Time     |
  14. --------------------------------------------------------------------------------------------
  15. |   0 | SELECT STATEMENT            |              |     1 |     8 |     1   (0)| 00:00:01 |
  16. |   1 |  TABLE ACCESS BY INDEX ROWID| PERSON       |     1 |     8 |     1   (0)| 00:00:01 |
  17. |*  2 |   INDEX UNIQUE SCAN         | SYS_C0010997 |     1 |       |     0   (0)| 00:00:01 |
  18. --------------------------------------------------------------------------------------------
  19.  
  20. Predicate Information (identified by operation id):
  21. ---------------------------------------------------
  22.  
  23.    2 - access("PERSON_ID"=3)
RAW Paste Data
Top