Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------------------------------------------------------------------------------------------------
- | Id | Operation | Name | ROWS | Bytes |TempSpc| Cost (%CPU)|
- -------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 209 | 85272 | | 54193 (1)|
- | 1 | SORT ORDER BY | | 209 | 85272 | | 54193 (1)|
- | 2 | HASH JOIN OUTER | | 209 | 85272 | | 54192 (1)|
- | 3 | NESTED LOOPS OUTER | | 209 | 75031 | | 34312 (1)|
- | 4 | NESTED LOOPS OUTER | | 209 | 65626 | | 34103 (1)|
- | 5 | NESTED LOOPS OUTER | | 209 | 55803 | | 33685 (1)|
- | 6 | NESTED LOOPS | | 209 | 46398 | | 33476 (1)|
- | 7 | VIEW | | 2781 | 404K| | 22352 (1)|
- | 8 | UNION-ALL | | | | | |
- | 9 | FILTER | | | | | |
- | 10 | CONNECT BY WITH FILTERING | | | | | |
- | 11 | NESTED LOOPS | | | | | |
- | 12 | NESTED LOOPS | | 1003 | 177K| | 6037 (1)|
- | 13 | HASH JOIN OUTER | | 1003 | 120K| | 4031 (1)|
- | 14 | HASH JOIN | | 1003 | 84252 | | 1338 (1)|
- | 15 | VIEW | VW_NSO_1 | 1 | 18 | | 1033 (1)|
- | 16 | HASH UNIQUE | | 1 | 94 | | 1033 (1)|
- | 17 | FILTER | | | | | |
- | 18 | HASH JOIN RIGHT OUTER| | 1003 | 94282 | 4512K| 1032 (1)|
- | 19 | INDEX FAST FULL SCAN| PK_WOWOB | 100K| 3330K| | 166 (1)|
- | 20 | INDEX FAST FULL SCAN| X_WOWOB | 100K| 5876K| | 305 (1)|
- | 21 | INDEX FAST FULL SCAN | X_WOWOB | 100K| 6464K| | 305 (1)|
- | 22 | VIEW | | 24541 | 934K| | 2692 (1)|
- | 23 | HASH GROUP BY | | 24541 | 1198K| 1752K| 2692 (1)|
- | 24 | INDEX RANGE SCAN | XI_APSTP | 24541 | 1198K| | 2386 (1)|
- | 25 | INDEX UNIQUE SCAN | PK_WO | 1 | | | 1 (0)|
- | 26 | TABLE ACCESS BY INDEX ROWID| WO | 1 | 58 | | 2 (0)|
- | 27 | NESTED LOOPS | | 1003 | 183K| | 11041 (1)|
- | 28 | HASH JOIN OUTER | | 1003 | 126K| | 9035 (1)|
- | 29 | HASH JOIN | | 1003 | 90270 | | 6342 (1)|
- | 30 | CONNECT BY PUMP | | | | | |
- | 31 | INDEX FAST FULL SCAN | X_WOWOB | 100K| 6464K| | 305 (1)|
- | 32 | VIEW | | 24541 | 934K| | 2692 (1)|
- | 33 | SORT GROUP BY | | 24541 | 1198K| 1752K| 2692 (1)|
- | 34 | INDEX RANGE SCAN | XI_APSTP | 24541 | 1198K| | 2386 (1)|
- | 35 | TABLE ACCESS BY INDEX ROWID| WO | 1 | 58 | | 2 (0)|
- | 36 | INDEX UNIQUE SCAN | PK_WO | 1 | | | 1 (0)|
- | 37 | HASH GROUP BY | | 775 | 123K| | 5271 (1)|
- | 38 | HASH JOIN | | 775 | 123K| | 5270 (1)|
- | 39 | NESTED LOOPS | | | | | |
- | 40 | NESTED LOOPS | | 1210 | 151K| | 3598 (1)|
- | 41 | INDEX RANGE SCAN | XI_APSTP | 1210 | 54450 | | 2386 (1)|
- | 42 | INDEX RANGE SCAN | PK_WO | 1 | | | 1 (0)|
- | 43 | TABLE ACCESS BY INDEX ROWID| WO | 1 | 83 | | 2 (0)|
- | 44 | TABLE ACCESS FULL | ITEM_CCN | 76449 | 2613K| | 1672 (1)|
- | 45 | TABLE ACCESS BY INDEX ROWID | WO_BOM | 1 | 73 | | 4 (0)|
- | 46 | INDEX RANGE SCAN | PK_WO_BOM | 1 | | | 3 (0)|
- | 47 | TABLE ACCESS BY INDEX ROWID | ITEM | 1 | 45 | | 1 (0)|
- | 48 | INDEX UNIQUE SCAN | PK_ITEM | 1 | | | 0 (0)|
- | 49 | TABLE ACCESS BY INDEX ROWID | WO | 1 | 47 | | 2 (0)|
- | 50 | INDEX UNIQUE SCAN | PK_WO | 1 | | | 1 (0)|
- | 51 | TABLE ACCESS BY INDEX ROWID | ITEM | 1 | 45 | | 1 (0)|
- | 52 | INDEX UNIQUE SCAN | PK_ITEM | 1 | | | 0 (0)|
- | 53 | VIEW | | 869K| 40M| | 19878 (1)|
- | 54 | HASH JOIN RIGHT OUTER | | 869K| 70M| 39M| 19878 (1)|
- | 55 | VIEW | | 824K| 29M| | 6885 (1)|
- | 56 | HASH GROUP BY | | 824K| 30M| 46M| 6885 (1)|
- | 57 | INDEX FULL SCAN | PK_WO_RTG | 869K| 32M| | 6885 (1)|
- | 58 | TABLE ACCESS FULL | WO_RTG | 869K| 38M| | 8611 (1)|
- -------------------------------------------------------------------------------------------------
- Note
- -----
- - 'PLAN_TABLE' IS OLD version
Advertisement
Add Comment
Please, Sign In to add comment
