Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Jul 18th, 2013  |  syntax: None  |  size: 0.94 KB  |  views: 34  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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)
clone this paste RAW Paste Data