PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- Plan hash value: 1435007170 ---------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 895 | | 749K (11)| 02:29:55 | |* 1 | FILTER | | | | | | | |* 2 | HASH JOIN RIGHT OUTER | | 901 | 787K| | 749K (11)| 02:29:49 | | 3 | INDEX FULL SCAN | PS0S_UNION_TBL | 22 | 484 | | 1 (0)| 00:00:01 | |* 4 | HASH JOIN | | 901 | 768K| | 749K (11)| 02:29:49 | |* 5 | HASH JOIN | | 901 | 744K| | 747K (11)| 02:29:34 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- |* 6 | HASH JOIN RIGHT OUTER | | 901 | 719K| 7640K| 747K (11)| 02:29:30 | | 7 | INDEX FAST FULL SCAN | PS0S_POSITION_DATA | 177K| 5554K| | 328 (12)| 0 |* 8 | HASH JOIN | | 205K| 153M| | 738K (11)| 02:27:47 | | 9 | INDEX FAST FULL SCAN | PS0TL_TRC_TBL | 268 | 10452 | | 2 (0)| 00 |* 10 | HASH JOIN RIGHT OUTER | | 204K| 145M| 14M| 738K (11)| 02:27:46 | | 11 | TABLE ACCESS FULL | PS_OH_S_SCH_CLD_DL | 284K| 11M| | 939 (18)| 00:00:12 |* 12 | HASH JOIN RIGHT OUTER | | 606K| 407M| | 716K (12)| 02:23:15 | | 13 | TABLE ACCESS FULL | PS_DEPT_TBL | 16907 | 742K| | 106 (9)| 00:00:02 | |* 14 | HASH JOIN | | 41M| 25G| | 711K (11)| 02:22:15 | | 15 | TABLE ACCESS FULL | PS_LOCATION_TBL | 13909 | 611K| | 105 (8)| 00:00:02 |* 16 | HASH JOIN | | 41M| 23G| | 706K (10)| 02:21:15 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 17 | TABLE ACCESS FULL | PS_JOBCODE_TBL | 11171 | 501K| | 130 (7)| 00:00:02 |* 18 | HASH JOIN | | 41M| 22G| 59M| 701K (10)| 02:20:16 | | 19 | MAT_VIEW ACCESS FULL | PS_JOB | 651K| 52M| | 11733 (19)| 00:02:21 | 20 | VIEW | | 16M| 7626M| | 287K (18)| 00:57:32 | |* 21 | HASH JOIN RIGHT OUTER | | 16M| 3986M| | 287K (18)| 00:57:32 | | 22 | TABLE ACCESS FULL | PS_OH_S_TL_ERNCD | 234 | 4914 | | 4 (0)| 00:00 |* 23 | HASH JOIN RIGHT OUTER | | 16M| 3640M| | 285K (18)| 00:57:09 | | 24 | TABLE ACCESS FULL | PS_OH_S_SCH_ASSIGN | 24600 | 960K| | 86 (16)| 00: |* 25 | MAT_VIEW ACCESS FULL | PS_TL_PAYABLE_TIME | 16M| 3012M| | 283K (17)| |* 26 | TABLE ACCESS FULL | PS_PERS_NID | 101K| 2784K| | 280 (18)| 00:00 | 27 | TABLE ACCESS FULL | PS_PERSONAL_DATA | 101K| 2685K| | 1241 (7)| 00:00:1 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 28 | SORT AGGREGATE | | 1 | 12 | | | | | 29 | FIRST ROW | | 1 | 12 | | 1 (0)| 00:00:01 | |* 30 | INDEX RANGE SCAN (MIN/MAX) | PS_S_UNION_TBL | 1 | 12 | | 1 (0)| | 31 | SORT AGGREGATE | | 1 | 14 | | | | | 32 | FIRST ROW | | 1 | 14 | | 1 (0)| 00:00:01 | |* 33 | INDEX RANGE SCAN (MIN/MAX) | PS_TL_TRC_TBL | 1 | 14 | | 1 (0 | 34 | SORT AGGREGATE | | 1 | 17 | | | | |* 35 | INDEX RANGE SCAN | PS_OH_S_TL_ERNCD | 1 | 17 | | 1 (0)| 00:00:01 | | 36 | SORT AGGREGATE | | 1 | 28 | | | | |* 37 | TABLE ACCESS BY INDEX ROWID | PS_OH_S_SCH_ASSIGN | 1 | 28 | | 3 (0)| |* 38 | INDEX RANGE SCAN | PS_OH_S_SCH_ASSIGN | 1 | | | 2 (0)| 00:00:01 PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 39 | SORT AGGREGATE | | 1 | 40 | | | | |* 40 | INDEX RANGE SCAN | PS_OH_S_SCH_CLD_DL | 1 | 40 | | 3 (0)| 00:00:0 | 41 | SORT AGGREGATE | | 1 | 21 | | | | | 42 | FIRST ROW | | 1 | 21 | | 3 (0)| 00:00:01 | |* 43 | INDEX RANGE SCAN (MIN/MAX) | PSDJOB | 1 | 21 | | 3 (0)| 00:00:01 | 44 | SORT AGGREGATE | | 1 | 24 | | | | | 45 | FIRST ROW | | 1 | 24 | | 3 (0)| 00:00:01 | |* 46 | INDEX RANGE SCAN (MIN/MAX) | PS_JOB | 1 | 24 | | 3 (0)| 00:00: | 47 | SORT AGGREGATE | | 1 | 23 | | | | | 48 | FIRST ROW | | 1 | 23 | | 2 (0)| 00:00:01 | |* 49 | INDEX RANGE SCAN (MIN/MAX) | PS_LOCATION_TBL | 1 | 23 | | 2 (0) PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 50 | SORT AGGREGATE | | 1 | 21 | | | | | 51 | FIRST ROW | | 1 | 21 | | 2 (0)| 00:00:01 | |* 52 | INDEX RANGE SCAN (MIN/MAX) | PS_JOBCODE_TBL | 1 | 21 | | 2 (0)| 00 | 53 | SORT AGGREGATE | | 1 | 17 | | | | | 54 | FIRST ROW | | 1 | 17 | | 3 (0)| 00:00:01 | |* 55 | INDEX RANGE SCAN (MIN/MAX) | PS_S_POSITION_DATA | 1 | 17 | | 3 (0)| | 56 | SORT AGGREGATE | | 1 | 24 | | | | | 57 | FIRST ROW | | 1 | 24 | | 2 (0)| 00:00:01 | |* 58 | INDEX RANGE SCAN (MIN/MAX)| PS_DEPT_TBL | 1 | 24 | | 2 (0)| ----------------------------------------------------------------------------------------------------