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