Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

SQL Explain

By: a guest on Aug 6th, 2010  |  syntax: None  |  size: 1.04 KB  |  views: 32  |  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.  
  2. PLAN_TABLE_OUTPUT
  3. --------------------------------------------------------------------------------
  4.  
  5. --------------------------------------------------------------------------------
  6. -
  7.  
  8. | Id  | Operation                    |  Name            | Rows  | Bytes | Cost
  9. |
  10.  
  11. --------------------------------------------------------------------------------
  12. -
  13.  
  14. |   0 | SELECT STATEMENT             |                  |     1 |    14 |  3080
  15.  
  16. PLAN_TABLE_OUTPUT
  17. --------------------------------------------------------------------------------
  18. |
  19.  
  20. |   1 |  SORT AGGREGATE              |                  |     1 |    14 |
  21. |
  22.  
  23. |   2 |   TABLE ACCESS BY INDEX ROWID| CLAIM_KEY        |  6531 | 91434 |  3080
  24. |
  25.  
  26. |   3 |    INDEX SKIP SCAN           | I_CLAIM_KEY_001  |  1306K|       |  2813
  27. |
  28.  
  29.  
  30. PLAN_TABLE_OUTPUT
  31. --------------------------------------------------------------------------------
  32. --------------------------------------------------------------------------------
  33. -
  34.  
  35.  
  36. Note: cpu costing is off, PLAN_TABLE' is old version
  37.  
  38. 11 rows selected.