Advertisement
grahn

Untitled

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