SHARE
TWEET

SQL Explain

a guest Aug 6th, 2010 36 Never
  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.
RAW Paste Data
Top