Advertisement
grahn

Untitled

Aug 12th, 2011
250
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.23 KB | None | 0 0
  1. Taken from http://pastebin.com/75QJ2ShD
  2.  
  3. -----------------------------------------------------------------------------
  4. | Id | Operation | Name | Rows | Actual Rows
  5. -----------------------------------------------------------------------------
  6. | 0 | SELECT STATEMENT | | 6 | 0
  7. |* 1 | VIEW | | 6 | 89200
  8. |* 2 | WINDOW SORT PUSHED RANK | | 6 | 89276
  9. | 3 | VIEW | | 6 | 89276
  10. | 4 | SORT ORDER BY | | 6 | 89276
  11. | 5 | UNION-ALL | | | 89276
  12. |* 6 | HASH JOIN SEMI | | 1 | 68076
  13. | 7 | NESTED LOOPS OUTER | | 1 | 68076
  14. | 8 | NESTED LOOPS | | 1 | 68076
  15. | 9 | NESTED LOOPS | | 1 | 68911
  16. | 10 | NESTED LOOPS OUTER | | 1 | 70025
  17. | 11 | NESTED LOOPS | | 1 | 72958
  18. | 12 | TABLE ACCESS BY INDEX ROWID| PS_PO_HDR | 568 | 86405
  19. |* 13 | INDEX RANGE SCAN | PS0PO_HDR | 1022 | 6185
  20. |* 14 | TABLE ACCESS BY INDEX ROWID| PS_PO_LINE_DISTRIB | 1 | 6185
  21. |* 15 | INDEX RANGE SCAN | PSBPO_LINE_DISTRIB | 80 | 2395163
  22. |* 16 | INDEX RANGE SCAN | PSAVENDOR | 1 | 2395163
  23. |* 17 | TABLE ACCESS BY INDEX ROWID | PS_RECV_LN_SHIP | 1 | 12151
  24. |* 18 | INDEX RANGE SCAN | PSARECV_LN_SHIP | 1 | 12151
  25. |* 19 | TABLE ACCESS BY INDEX ROWID | PS_VOUCHER_LINE | 1 | 70025
  26. |* 20 | INDEX RANGE SCAN | PSCVOUCHER_LINE | 1 | 72349
  27. |* 21 | INDEX RANGE SCAN | PSJVOUCHER | 1 | 68911
  28. | 22 | VIEW | VW_NSO_1 | 12151 | 82352
  29. |* 23 | FILTER | | | 68076
  30. |* 24 | HASH JOIN | | 12151 | 68911
  31. | 25 | INDEX FAST FULL SCAN | PS_ING_BARGESPECIF | 12151 | 14552
  32. | 26 | INDEX FAST FULL SCAN | PS_ING_BARGESPECIF | 12151 | 68076
  33. | 27 | HASH GROUP BY | | 5 | 21200
  34. | 28 | NESTED LOOPS | | 5 | 21401
  35. |* 29 | HASH JOIN SEMI | | 5 | 21401
  36. | 30 | NESTED LOOPS | | 6 | 21836
  37. | 31 | NESTED LOOPS | | 2409 | 21738
  38. | 32 | INLIST ITERATOR | | | 6185
  39. |* 33 | TABLE ACCESS BY INDEX ROWID| PS_VOUCHER | 2465 | 6185
  40. |* 34 | INDEX RANGE SCAN | PSJVOUCHER | 4461 | 2395163
  41. |* 35 | TABLE ACCESS BY INDEX ROWID | PS_VOUCHER_LINE | 1 | 2395163
  42. |* 36 | INDEX RANGE SCAN | PS_VOUCHER_LINE | 1 | 12151
  43. |* 37 | TABLE ACCESS BY INDEX ROWID | PS_DISTRIB_LINE | 1 | 12151
  44. |* 38 | INDEX RANGE SCAN | PS_DISTRIB_LINE | 1 | 27233
  45. | 39 | VIEW | VW_NSO_2 | 12151 | 21836
  46. |* 40 | FILTER | | | 21836
  47. |* 41 | HASH JOIN | | 12151 | 21401
  48. | 42 | INDEX FAST FULL SCAN | PS_ING_BARGESPECIF | 12151 | 21836
  49. | 43 | INDEX FAST FULL SCAN | PS_ING_BARGESPECIF | 12151 | 14552
  50. |* 44 | INDEX RANGE SCAN | PSAVENDOR | 1 | 0
  51. -----------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement