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